baabhu (10/19/2012)
We managed to schedule it that 4 minutes job starts at odd minutes and the 10 minutes job starts at even minutes.Chances of intersecting is very rare.
NOt exactly. think.. if first job will take more then 1 minute so run will get conflict.So in this way you cant restrict or manage the job run
instead. combine the jobs as Step1 and step 2 and also look into the invloved sql script to tune them as Grant mentioned above.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)