SQL Agent Job - Logging results to a table.

• Warren Peace

  SSCertifiable

  Points: 5871

  More actions

  October 11, 2007 at 12:06 pm

  #198898

  Is it possible to log the results of a SQL Agent job to a specific table?

  I see there is a tick box for logging to a table for each step in the job but it does not allow me to tell it which table I want it to log to.

  Can someone give instructions on how to log a SQL Agent job and/or steps within the job to a specific table?

  Thanks

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  October 11, 2007 at 12:52 pm

  #741331

  Job execution info is automatically stored in the sysjobhistory table in msdb. Does that meet your needs?

  Greg

  Greg