DTS Scheduling

[tlaksh]

I have a dts that i want to run at different times e.g every 10 min,30min,6hrs etc. Each time the dts runs for different servers...

Now i have created respective number of jobs and the first step in each job is to pick the servername.

Sometimes the times overlap each other and the dts fails because another job is using it.

Is there anyway that i can avoid this..or is there a better way of scheduling the same dts.

Thanks for all ur help

Lakshmi.

 

[rajeevnandanmishra]

Hello tlaksh,

What i understand is, the jobs are failing because of overlapping.
The same type of problem we were facing in our company also.
What we had done, is
1) Create a Single Job.
2) And run your DTS in different steps of the same job.

Then they will bound to run sequentially.
You can also manage the actions, you want to do, if the previos step is failed or completed successfully.

Hoping this will help you.