DSXchange

Hi,

Can I time slice the parallel jobs? What I mean is: say, I have to load 4 tables of 10 million rows each. Assuming each parallel job takes around 20 minutes to load each table, to start with job1, can I schedule job 2 to run 15 minutes after the first job (overlap of jobs 1 and 2) and after 10 minutes of start of job 2, can I schedule job 3 and so on? In that case, what are the issues that I may face? How does Parallel Extender react to this situation? Overall, what's the overhead?

Cheers,
Mohan

No.

Parallel means parallel. They run simultaneously.

You can do what you want by creating multi-instance server jobs, and controlling those through a job sequence.