Sending an Alert via RAISERROR

[jeannelc]

HELP!! I'm running SQL Server 7.0.

I am trying to send an alert via net send (since for many reasons I cannot use email). I have one set up on my development server that works fine, but I can't duplicate it on my production server.

The problem seems to be with getting the alert to fire in general AND with net send.

Here are the steps I take:

I have a user error message set up - 500001. The message is logged.

I have a job that runs a query and calls the error message in RAISERROR

I have an alert configured that triggered for error 500001. This alert is supposed to notify operator Jeanne via net send. The alert writes to the log.

I can manually run the query successfully -- it raises the error correctly.

The job runs correctly as scheduled.

The alert is never fired -- shows as never occurred via Enterprise manager.

WHY NO ALERT?

Net send works when I send a test to operator Jeanne BUT I also tried setting up notification in the job wizard. It said it sent it via net send but I never got it.

ANY IDEAS? Jeanne Clotfelter
Database Analyst IT
Computer Technologies
Kentucky State Police

 

[Bernadette]

Hi There Jeanne

Does the alert fire without netsend ?

Hope This Helps
Bernadette

 

[jeannelc]

Thanks,

The problem was with net send -- it wasn't working properly. I restarted messenger service and all is well Jeanne Clotfelter
Database Analyst IT
Computer Technologies
Kentucky State Police

 

[Bernadette]

Glad you sorted it out Jeanne
Have a good weekend Hope This Helps
Bernadette