SQL Server Performance

Valid error number

Discussion in 'Getting Started' started by jogin malathi, Jun 11, 2007.

  1. jogin malathi New Member

    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
  2. Madhivanan Moderator

  3. satya Moderator

    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.

Share This Page