Alert not firing!
-
I have recently set up an alert which will not fire. I have looked at Microsofts Troubleshooting Alerts and appear to be doing everything asked of me. The error is written to both the sql server log and the windows application log. The alert and job are both enabled. I am running SQL2K with no service packs applied. This is on a WIN2K box.
Any ideas?
-
Can you give some more details about the alert ?
-
First, you really need to apply the service packs. Lots of bugs and issues are fixed in them. Sp3a is the latest.
From there, definitely more details are needed.
-
If you use "net send" as notification method, make sure that domain policy allows "net send".
-
1) You'll have to stop/start sqlagent if it is the first alert you've defined where sql has to perform some stuff.
2) keep up with servicepacks ! the sqlserver engine gets better and better each time !
(sp3a is the current)Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Don't forget to check permissions. Look for the User Account that is the owner of your newly created job. Also, check the User Account that Sql Server Agent service is running under. Go to Start/Settings/Control Panel/Admin Tools/Services. Check the Properties of SQL Agent.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply