Reg. SQL Server job

• systems.blr

  SSC Rookie

  Points: 30

  More actions

  July 26, 2011 at 5:51 am

  #244979

  Hi i am using sql server 2008.

  In sql server 2008 i have scheduled 5 jobs in all different times.

  if any 1 job get fail means another job will execute or it will stop executing the remaining jobs?

• M&M

  SSC-Insane

  Points: 21700

  More actions

  July 26, 2011 at 6:02 am

  #1358405

  No, it wouldn't matter. The jobs will run based on the schedule.

  M&M

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  July 26, 2011 at 8:25 am

  #1358553

  Jobs are separate entities, the run on whatever schedule you have setup and if one fails the others keep going.

  CEWII