Scheduler Usage

Hi,

I don't know anything about Informatica WorkFlow.
So, as some other tools as GENIO for example you can invoke in Command Line some order.

If all your treatment is managed only by Informatica it will be difficult to build a scenario with Control-M.

The most important will be to split your treatment as a single step and launch with a Control-M job each of them and detect exit code more easily.

In your case :
Job 1 to extract from Sybase
Job 2 to load data in Orcale
and different other jobs to start dataserver or to relaunch extraction in cas of Job 1 exit with an error different of 0.

I hope to have helped you.

de toute fa?on l'import / export peut ?tre ind?pendant du type de base non?
si j'utilise ecs util / import_def_table ... j'ai les m?mes utilitaires pour oracle non ?

Mozes pisat anglicky?
Tiez mozem pouzivat materinsky jazyk, ale asi to pre viacerych nebude uzitocne.
Nemyslis?
----
can you write in English please?
I can use my native language too, but it wont be helpfull for most peoples. Don't you think?

Hi philmalmaison

Be carefull about your answer.
That post didn't concern jobs defintion extraction between sybase and oracle.

It concerned some possibilities to extract applicative data from a sybase dataserver to an oracle dataserver.

so what is about the control-m in this question ... ? ...

I am sorry to go out of the topic and ask you, but I am curious to know that where do you work? becasuse your name sounds like indian and I am new to Control-M , so I want to know where else Control-M is being used.


Thanks&Regards
sharaschandra

Hi Ravikumar, we use Ascential datastages as ETL tool, what we generally do in + testing is , just trigger the ETL job from Control-M job using some unix shell scripts and see if it is triggering the ETL job and getting the perfect return codes back in the SYSOUT. And in -VE testing we trigger the job in the same way and then kill the job to see if it is getting killed and make sure all the shouts are performed..

thanks,

doesn't matter to ctrlm how to extract, then upload, why are you searching that kind of experience here ? ...

any data migration process depend of the context no ?

regards
Philmalmaison