Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Jobs Audit

Author  Topic 

fvinagre
Starting Member

29 Posts

Posted - 2004-11-24 : 04:37:14
Hi dbas

Is posible audit if an user is enabling or disabling a Job in sql server?

Regards
Fernando

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-11-24 : 04:56:51
based from my experience, possible but not direct.

also not sure if the modified date on sysjobs pertains also for disable/enable actions.

actually, i believe only process admins and sysadmins can enabled or disable a job. so you'll probably get a shorter list.

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -