Many failed jobs (urgent help!)

• Dony

  Ten Centuries

  Points: 1317

  More actions

  September 24, 2007 at 4:07 pm

  #118719

  Hi,

  I got a very bad day today. There are many failed jobs in my scheduled jobs. Can somebody give me some quick solutions? Now I am just preparing to migrating to new server box. :w00t:

  Many thanks.

  Don

• Jo Pattyn

  SSC-Dedicated

  Points: 32350

  More actions

  September 26, 2007 at 3:23 am

  #736283

  find out why they failed at the job logs? Anything curious in the server log?

• abdulkboy

  SSC Veteran

  Points: 212

  More actions

  September 27, 2007 at 10:12 am

  #736842

  This is how you can check why the jobs failed.

  SQL 2000

  Enterprise manager-->management-->SQL Server Agent-->Jobs

  SQL 2005

  SSMS-->SQL Server Agent-->Expand Jobs

  Learning never ends!:P