VIVEKANANDHAN_PERIASAMY
asked on
I WANT TO KNOW WHO HAS DISABLE THE SQL JOBS
I am able to find the details from SELECT top 1 * FROM DBO. sysjobsteps
SELECT top 1 * FROM DBO. sysjobhistory for the last run.
But i am not getting the details who has disabled the job.How to get this details?
SELECT top 1 * FROM DBO. sysjobhistory for the last run.
But i am not getting the details who has disabled the job.How to get this details?
what do you mean by disabled?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
He means to disable the job so it won't execute: right click on job name in SQL Agent node > Disable.
ASKER
what do you mean by disabled? someone has disabled the jobs for a longtime.I need find who has disabled it.
You can't.
Or to put it more bluntly, since you are asking you can't. In other words, if you had taken some proactive steps as suggested previously, you would know the answer to that question, since you obviously have not, there is nothing you can do about it. You are SOL.
Also please lose the ALL-CAPS it looks like you are yelling.
ASKER
Also please lose the ALL-CAPS it looks like you are yelling.
Hello Acperkins-> can i know what are trying to say here..
Hello Acperkins-> can i know what are trying to say here..
chek the sql server agent logs and event vieiwer
ASKER
No, i have investigate a lot... i didn't get any details
Have you seen my post? Is not possible to see that unless you set it up. By default the audit on sysjobs table is not on.
>>Hello Acperkins-> can i know what are trying to say here.. <<
I realize English is not my first language, but surely you can see that your title is written in ALL-CAPS and this is contrary to the EE Guidelines.
P.S. Most people here call me by my name: Anthony
I realize English is not my first language, but surely you can see that your title is written in ALL-CAPS and this is contrary to the EE Guidelines.
P.S. Most people here call me by my name: Anthony
Just to make sure, don't forget to take a look at this:
Here: http://www.bimonkey.com/2009/12/sql-server-2008-auditing/
Here: http://www.bimonkey.com/2009/12/sql-server-2008-auditing/