July 12, 2004 at 10:12 am
Environment: SQL 2000 SP3, Win2K Server SP unknown
I've set up an alert with an error code of 78000, and fired it using RAISERROR (78000, 10, 1) in Query Analyzer. The error message associated with the alert shows up properly in the current SQL Server Event Log, but the associated operator is not notified via e-mail/pager/NetSend, and the alert still shows up in the EM Alert list as (Never Occurred).
I've verified that the SQL Server Agent is running, the alert is enabled, the operator is enabled and 'on duty' at the time I issue the RAISERROR. I've also tried firing it with a severity level of 16, with the same results.
What else could be wrong?
TIA,
Matt Gauch
Kindest Regards,
Matt Gauch
July 12, 2004 at 5:50 pm
July 12, 2004 at 11:59 pm
What message are you getting in the event log? Your message, or the generic (see my later post "The description for Event ID...") one with yours buried in the end?
July 13, 2004 at 2:12 am
i've had something similar, i never tracked the problem down exactly, but it was due to the content of the email it was sending.
do you have other alerts working correctly??
I sent the phrase CE90 in the text of one alert. either the email filters or something picked this up as a control character and scrubbed the email.
changing it to CE 90 (putting a space in) solved my problem
MVDBA
July 13, 2004 at 8:35 am
MY message shows up in the log, not the generic one, and SQL Mail is configured properly - I receive test e-mails AND pages when I test those for the operator.
Kindest Regards,
Matt Gauch
July 13, 2004 at 8:44 am
try manually running an XP_SENDMAIL with the exact data that SQL would use.
this may not be SQL server, but something else picking up the email due to the content.
as i said before
This didn't send anything
XP_Sendmail @recipient='xyz@abc.com',@message='Database backed up sucessfully for database CE90'
this one did (due to the CE90)
XP_Sendmail @recipient='xyz@abc.com',@message='Database backed up sucessfully for database CE 90'
there may be something in the text that is being picked up as a control code.
MVDBA
July 13, 2004 at 3:35 pm
No such luck. I copied the text out of the log, and pasted it into a call to XP_SENDMAIL - it came through to both my e-mail inbox and pager just fine. Any other ideas?
Kindest Regards,
Matt Gauch
July 13, 2004 at 6:28 pm
BOL says:
Severity levels from 19 through 25 send a Microsoft® SQL Server™ message to the Microsoft Windows® application log and trigger an alert. Events with severity levels less than 19 will trigger alerts only if you have used sp_altermessage, RAISERROR WITH LOG, or xp_logevent to force them to be written to the Windows application log.
So, to recive an alert when I do a stupid query such as...
select splotbot from kajingg
and get the error:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'kajingg'.
I have to hop into Query analyser and do this before it will email me, even though I have defined an alert for severity 16 errors (or message 208)....
sp_altermessage 208, 'WITH_LOG', 'true'.
Somewhat obscure.
DB
The systems fine with no users loggged in. Can we keep it that way ?br>
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply