SQL Server Alert System: error 1205

[deeman]

I'm trying to set up a SQL Alert to notify me when deadlocks are experienced on our servers.

I've set one up on a SQL2000 instance which works fine; when I generate a deadlock, the alert registers the occurance of the error and fires off an email.

I've set up the same alert on a SQL7 instance which does not register the occurance of the error nor sends the notification email.

Both alerts are identical, as are the scripts i'm using to generate a deadlock.

Any help in diagnosing this problem would be very much appreciated.

Thanks.

[rmiao]

Does sql agent running on sql7 server?

[deeman]

Yes, SQL Server Agent is up and running on the SQL 7 instance.

[MAK]

Make sure the account used for sql server agent has access.

if not the job will not run.