Post reply

SQL Server Job Agent Job Category !!!

  • April 20, 2008 at 10:43 pm

    #380076

    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 just want to know this for Auditing purpose.

    i just want to keep a track what new job categories have been deleted or new Job categories have been added on so and so dates.

    Hint:

    -----

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

    Any Thoughts????

  • April 21, 2008 at 3:36 am

    #804809

    You can create a trigger on the syscategories table in msdb, which logs all the changes.

    [font="Verdana"]Markus Bohse[/font]

  • April 24, 2008 at 5:54 am

    #806487

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply