Help with logs for SQL Server Job

• Maruthi Shangar

  SSC Enthusiast

  Points: 169

  More actions

  January 5, 2009 at 12:03 am

  #155083

  I have a Job scheduled to execute a procedure in SQL server 2000. I am able to look into the history of the job by right clicking on the job in Enterprise manager. Is there some way, by which the logs can be entered into a text file.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 5, 2009 at 6:56 am

  #921098

  You can use Query Analyzer to query msdb.dbo.sysjobhistory and sysjobs and set the output to a text file.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question