timscronin
MIS
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
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