June 3, 2008 at 9:25 am
We have several DBAs working on our systems. I had a situation where a job that needed to run was deleted accidently by another DBA. Two weeks passed before I realized the job was gone. I wondered if anyone could tell me the best way to get alerted when this occurs? I thought maybe a DDL trigger might work but I'm not certain this is the what i'm looking for.
June 3, 2008 at 9:30 am
gunna48 (6/3/2008)
We have several DBAs working on our systems. I had a situation where a job that needed to run was deleted accidently by another DBA. Two weeks passed before I realized the job was gone. I wondered if anyone could tell me the best way to get alerted when this occurs? I thought maybe a DDL trigger might work but I'm not certain this is the what i'm looking for.
Your probably right, some sort of delete trigger on the msdb.dbo.sysjobs table would probably do the trick.
June 3, 2008 at 2:46 pm
Well according to what I've read you can't use a dml trigger on system databases and I can't find an event type for ddl so I'm going to have to do something different. Anyone have any suggestions?
June 3, 2008 at 2:48 pm
You can buy a product like Idera's Compliance Manager. It can be set up to send alerts for all different types of operations.
June 3, 2008 at 3:37 pm
You could look at setting up an alert for "14238" but because we can't make it "logged" in 2005 it probably wouldn't work.
I would still give it a go... in case I am wrong 😉
* Noel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply