How to store SQL Agent Job Step output messages to a custom table?

• Siddharthan, Kannan

  SSC Enthusiast

  Points: 178

  More actions

  July 4, 2008 at 4:09 am

  #190230

  By default the Job Step output messages are written to msdb..sysjobstepslogs. Is it possible to write the message to a custom table?

  Your help is much appreciated.

  Thanks,

  Siddharth

• A_A_R_T

  SSC Eights!

  Points: 900

  More actions

  July 4, 2008 at 4:53 am

  #838310

  Yes, that is possible. You can put a trigger on the table msdb.sysjobstepslogs which inserts the data you want to another table.