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 2005 Forums
 SQL Server Administration (2005)
 SQL Server Job Agent !

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2008-04-21 : 00:39:44

Hi pals,

I am using sql server 2005.

Is there any means to check/see the log if i add a new job category has been added or deleted .

I need this for Auditing Purpose.

Hint:
-----

Management Studio-->Jobs-->Right Click-->Manage Job Categories-->Add/Delete.

Any Thoughts ???

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-21 : 23:19:20
Check msdb..syscategories in scheduled time.
Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2008-04-24 : 07:52:37
But i am looking for a log if any when a Job Category is Added / Dropped.

Thanks!
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-24 : 10:03:07
You can't see in log .Just do what rmaio has said
Go to Top of Page
   

- Advertisement -