Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    35

    Unanswered: SQL Agent Job - Logging results to a table.

    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

  2. #2
    Join Date
    Oct 2007
    Location
    Chicago, IL
    Posts
    82
    SQLAgent writes the history log records to the sysjobhistory table in msdb. I supposed you could copy records from sysjobhistory to a different table? Why is this needed?

  3. #3
    Join Date
    Oct 2007
    Posts
    35
    The developer asked for this. We're already logging correctly to a text file.

    Thanks for you help. I'll check into the table you suggested in a few minutes.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •