hi all, Here iam creating alerts i want to raise alert when job executes for that their is a option called error number it asks for valid error number how should i enter number Thanks in Advance Malathi Rao
http://www.sommarskog.se/error-handling-I.html http://www.sommarskog.se/error-handling-II.html Madhivanan Failing to plan is Planning to fail
If you want to set alert when a job is starting then you can set the alert notification. You can take help of KBAhttp://support.microsoft.com/kb/908360 and also using WMI providerhttp://technet.microsoft.com/en-us/library/ms186385.aspx in this case. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
