Home Forums SQL Server 2008 SQL Server 2008 - General Qusestion on delete job RE: Qusestion on delete job

  • October 20, 2012 at 8:38 am

    #1551116

    Bhuvnesh (10/19/2012)

    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.

    Hi Bhuvnesh,

    Thanks for your explanation. We changed our code to check the status of the jobs. If one job is executing the other job will not start. When jobs intersect as you said, it will exit and wait for the next turn.