Valid error number | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Valid error number

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.
]]>