Saturday, February 25, 2012

Audit history for scheduled jobs (SQL Server 2000)

Hello,

I would like to be able to set up an audit of changes that are made to scheduled jobs, so that a history can be built up of of these changes. Anyone any ideas on how to do this?

Thanks

You can create a query to do a SELECt on the sysjobs table in the MSDB database

No comments:

Post a Comment