August 16, 2006 at 11:32 pm
Can anyone successfully create and then trigger an alert for Error 15327 - "Database is now offline" in SQL Server 2000. I've tried, but my alert is not fired when a database is taken offline, despite setting the error to write to the event log through EM's Alert creation wizard. The event does not write to the event log.
Granted, Error 15327 is not necessarily an error and has severity zero, but nonetheless I need this notification and SQL Server should be able to make it happen. Many thanks.
August 21, 2006 at 8:00 am
This was removed by the editor as SPAM
August 21, 2006 at 2:58 pm
Try stopping and restarting SQL Server Agent after setting up the alert.
Greg
Greg
August 24, 2006 at 1:26 am
Still doesn't work despite stopping and starting the agent. I appreciate the suggestion though,
Greg.
Can anybody get this alert working on their SQL Server 2000 installation? Give it a try. It takes a few minutes to set up. If not, then it is a bug. I have the latest service pack installed.
August 24, 2006 at 4:50 pm
I tried your error number and took the db offline via sp_dboption. I didn't get alerted.
I also tried 942 and then tried use dbname ... go in QA and see log entries in the event log and sql error log but still no alert gets fired.
Now I'm hooked into this loop....
going further..... from 2k5 BOL .... to get logged/alerted, events must have severity levels from 19..25. For my 942 example, this works for me.... however, only after manually updating msdb..sysalerts to have a severitylevel of 19 for my test alert id. This same trick didn't work for 15327... yet.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply