SQL Server Performance Forum – Threads Archive
Valid error numberhi 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
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
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.