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?
LVL 5
VIVEKANANDHAN_PERIASAMYAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LowfatspreadCommented:
what do you mean by disabled?
ZberteocCommented:
You probably can't unless you create a trigger on msdb.dbo.sysjobs table on UPDATE and store the YSTSEM_USER and HOST_NAME() in a audit table together with the change it made:


SELECT SYSTEM_USER,HOST_NAME ( )

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ZberteocCommented:
He means to disable the job so it won't execute: right click on job name in SQL Agent node > Disable.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

VIVEKANANDHAN_PERIASAMYAuthor Commented:
what do you mean by disabled?  someone has disabled the jobs for a longtime.I need find who has disabled it.
Anthony PerkinsCommented:
You can't.
Anthony PerkinsCommented:
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.
Anthony PerkinsCommented:
Also please lose the ALL-CAPS it looks like you are yelling.
VIVEKANANDHAN_PERIASAMYAuthor Commented:
Also please lose the ALL-CAPS it looks like you are yelling.

Hello Acperkins-> can i know what are trying to say here..
Ramesh Babu VavillaCommented:
chek the sql server agent logs and event vieiwer
VIVEKANANDHAN_PERIASAMYAuthor Commented:
No, i have investigate a lot... i didn't get any details
ZberteocCommented:
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.
Anthony PerkinsCommented:
>>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
ZberteocCommented:
Just to make sure, don't forget to take a look at this:

Here: http://www.bimonkey.com/2009/12/sql-server-2008-auditing/
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.