I am not 100% sure, but i think i had a SQL job in one of my instance. But I can not see it now. it seems that somebody deleted that. I need to get evidence that there was truly a sql job in my instance. is there any system table that hold the information of all the job that was created into the instance even it is deleted. i can only see the current jobs in MSDB database. but i need to see that job there was but not any more.Thanks
asked Mar 28, 2012 at 04:12 PM in Default
Assuming that if it was deleted that the job history was not removed along with it, you should be able to find traces of it in
Can't promise anything, but that might be a place to start.
answered Mar 28, 2012 at 08:07 PM
Another thought, do you currently back up the MSDB database? If so, do you have a valid backup (from the time that you thought that the job was present) that you might be able to restore somewhere to see if the job is present?
Just a thought.As a side note, if you are not backing it up, you should. ;-)