One Thousand Jobs' Sequence
Posted: Fri Jan 22, 2010 2:24 pm
Guys,
I've around 1100 parallel jobs which migrating data from an older version of Oracle to Oracle 10g. Each job only captures the changes between data source and destination on daily basis.
The used job's pattern is:
ODBC Stage --> Transformer Stage to capture data changes --> Oracle Enterprise Stage
I need your advice about how should I implement the job sequence which run all of these jobs. In other words, what are the aspects should I talk into consideration when developing such sequence?
For example, putting each 50 or 100 jobs together on a batch job then gatehring all in a job sequence, or depending on the size of tables that jobs transfer,...etc.
Talking into consideration that the largest table contains around 2 million records.
Your suggestions will be valuable for me.
Regards.
I've around 1100 parallel jobs which migrating data from an older version of Oracle to Oracle 10g. Each job only captures the changes between data source and destination on daily basis.
The used job's pattern is:
ODBC Stage --> Transformer Stage to capture data changes --> Oracle Enterprise Stage
I need your advice about how should I implement the job sequence which run all of these jobs. In other words, what are the aspects should I talk into consideration when developing such sequence?
For example, putting each 50 or 100 jobs together on a batch job then gatehring all in a job sequence, or depending on the size of tables that jobs transfer,...etc.
Talking into consideration that the largest table contains around 2 million records.
Your suggestions will be valuable for me.
Regards.