I am a bit confused, please help :-)

What I am trying to do is duplicate data from oracle to MySql, which :

each migration of table contain this steps :

1. call Store Procedure in mysql (to log that the job is start)
2. call job from OrcleIn to MySqlOut (success)
3. call SP again in MYSQL to log that job is end

My question is :
1. how to connect and use the SP ?
2. how to set the first, second, third job to run ?

Thanks.

Last edited by Frendy (2012-06-15 08:50:30)