Check Job/Scheduled - Disabled/Enabled - Help!!

  • I need to verify whether a particular job and scheduled was enable or disabled at some date in past. Is there any way i can validate this? Please advise..thanks in advance

  • I am not aware of any history being kept on this column.

    But if you have some older backups of msdb you could certainly restore them and then check the sysjobs table to see if it is enabled/disabled in those backups. That could be very time consuming, and you probably do not keep weeks of msdb backups on disk, but that would be a way to check. I do not know of any other way, hopefully someone else will have a better option for you.

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

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