Post reply

View History for a job not in Log File Viewer

  • November 30, 2008 at 5:24 pm

    #202152

    HI all,

    I need to find whether a backup job failed or succeeded 2 days ago. I will usually get an email when the job fails, but the backup files aren't where they should be.

    Looking at the job history doesn't help, as it only shows records going back ~36 hours. Is there any way to show the data before this?

    Thankyou in advance,

    Ryan

  • November 30, 2008 at 6:03 pm

    #905334

    It seems like I've solved my own problem.

    I restored a backup of the msdb database we had for that morning, and was able to:

    SELECT *

    FROM msdb_temp.dbo.[sysjobhistory]

    Hope this helps anyone else in this predicament 🙂

    Ryan

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply