Post reply

Deleted Jobs History

  • November 23, 2015 at 9:41 pm

    #305489

    Accidentally deleted some jobs,anyway to get the history of those?

  • November 23, 2015 at 9:54 pm

    #1841915

    Use a non-production system (running the same SQL Server version and build as the "production" system) to backup its current msdb and restore production's msdb from its backup. Script out the jobs (and select its job history, if really needed), and save the scripts in your disaster recovery folder. Restore the backup of the current msdb (if needed). If you have no backups you are out of luck.

  • November 23, 2015 at 10:21 pm

    #1841918

    You can find the job history in

    select * from msdb.dbo.sysjobhistory

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

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