Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alert will not fire

Status
Not open for further replies.
Jun 27, 2001
837
0
0
US
I have a defined alert associated with an error message number. When I run Raiserror to test it logs the error in SQL and event logs, but it does not fire the alert to send out an email.
Here is the messge that was added

sp_addmessage @msgnum = 85009,
@severity = 10,
@msgtext = 'Problem with Rosetta server in Michigan',
@with_log = 'true'

and here is the raiserror

raiserror (85009,10,1)

What am I missing
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top