July 13, 2011 at 7:07 am
Hi Folks
I am wondering how to find that who enabled the job; I don't want to run [possibly login ID].
Is there a way to find out when its enabled last time and who enabled it.I am not aware if its possible to find out even if someone has logged on to the server remotely and enabled the job.
Background: I have two jobs; both comes with same output. One is all steps togather; other one split down in further steps. Last night my 2nd job ran some how and obviousley conflicted with the already running job and cause the system to fail.
Thanks much for your help
Imran
July 13, 2011 at 8:55 am
select * from msdb..sysjobs
will tell you the last time the job was modified.
If it was truly enabled (from a disabled state) the date it was enabled will be stored here.
You won't get the culprit, however.... that information is not stored.
~C
Craig Outcalt
July 13, 2011 at 9:26 am
Thanks Craig,
That's where I was looking already but it does not give me the full details.
I am going to watch tonight if its getting enabled itself on schedule time as I have disabled that job now.
Cheers
Imran
July 13, 2011 at 12:08 pm
Have you thought about the idea that it might be auto-disabled / enabled via a job?
Search the text (column name might be "Command") in sysjobsteps and see if you can find a step executing the system sproc that does this.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply