Wednesday, March 21, 2012

logs of creating and deleteing jobs

Hello
Does anybody know where/if MSSQL (especially 2005) keeps logs of
creating and deleteing jobs?

Thanks in advance
BartoloNo, it does not. Jobs are simple entries in the MSDB database, if you
want to keep track of that you will either have to tweak the appropiate
procedure that access these tables or write a trigger on the tables if
you are not sure if someone directly manipulates the tables.

HTH, Jens Suessmeyer.

--
http://www.sqlserver2005.de
--|||Thanks Jens,
I wrote that because, I realized that one of my db haven't got backup
job since few days. Job had been written before and I dont know who
could do that or why it disappeard.

Regards,
Bartolosql

No comments:

Post a Comment