Link to home
Start Free TrialLog in
Avatar of VIVEKANANDHAN_PERIASAMY
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?
Avatar of Lowfatspread
Lowfatspread
Flag of United Kingdom of Great Britain and Northern Ireland image

what do you mean by disabled?
ASKER CERTIFIED SOLUTION
Avatar of Zberteoc
Zberteoc
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
He means to disable the job so it won't execute: right click on job name in SQL Agent node > Disable.
Avatar of VIVEKANANDHAN_PERIASAMY
VIVEKANANDHAN_PERIASAMY

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.
Also please lose the ALL-CAPS it looks like you are yelling.

Hello Acperkins-> can i know what are trying to say here..
chek the sql server agent logs and event vieiwer
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
Just to make sure, don't forget to take a look at this:

Here: http://www.bimonkey.com/2009/12/sql-server-2008-auditing/