|
Hi, 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
(comments are locked)
|
|
You can get job_id for any created job from dbo.sysjobs table in MSDB database. In case the job is deleted and created again the job_id will be different.
(comments are locked)
|
|
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 or Can't promise anything, but that might be a place to start. John I think job history is vanished when job is deleted.
Mar 28 '12 at 08:23 PM
inder
Usually yes, but we don't know how it might have been deleted. You can delete a job and retain the history if specified. http://msdn.microsoft.com/en-us/library/ms188376%28v=sql.105%29.aspx As I mentioned, I assumed that if there is any remains, they might be able to locate traces of it in the tables mentioned. My guess is that there isn't any history, but you never know. =)
Mar 28 '12 at 09:02 PM
JohnM
(comments are locked)
|
|
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. ;-)
(comments are locked)
|
