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?
0
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 ( )
0

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.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

VIVEKANANDHAN_PERIASAMYAuthor Commented:
what do you mean by disabled?  someone has disabled the jobs for a longtime.I need find who has disabled it.
0
Anthony PerkinsCommented:
You can't.
0
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.
0
Anthony PerkinsCommented:
Also please lose the ALL-CAPS it looks like you are yelling.
0
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..
0
Ramesh Babu VavillaCommented:
chek the sql server agent logs and event vieiwer
0
VIVEKANANDHAN_PERIASAMYAuthor Commented:
No, i have investigate a lot... i didn't get any details
0
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.
0
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
0
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/
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.