Run Single Job instead of Multiple Jobs

• parthi-1705

  SSCrazy Eights

  Points: 9277

  More actions

  January 17, 2010 at 11:02 pm

  #219385

  Hi

  I am having a server in that nearly 100 databases are there.I have scheduled Job for every 15 min.This Job will run on all databases individual at same time say it Starts at 01:00 AM in morning all the 100 jobs will be running by 01:00 AM Is this a good one or can i clump those job in to single Job by

  EXEC Abc.dbo.Job1

  EXEC Efg.dbo.Job2

  EXEC Tre.dbo.Job3...

  EXEC Qwe.dbo.Job100

  Thanks

  Parthi

  Thanks
  Parthi

• Ahmad Osama

  SSCertifiable

  Points: 7676

  More actions

  January 18, 2010 at 12:53 am

  #1104808

  A single job with a step for each database will be easy to handle and it is what i recommend

  Regards,
  [font="Verdana"]Sqlfrenzy[/font]