Explicitly fail a SQL Server Job in SQL Server 2000

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Justin
    #1

    Explicitly fail a SQL Server Job in SQL Server 2000

    I have a SQL Server job, which runs mutiple steps. One of the steps
    (step 3) looks for a record in the database. How can I explicitly fail
    the SQL server job if the database record does not exist?

    Tags: None
    • Simon Hayes
      #2
      Re: Explicitly fail a SQL Server Job in SQL Server 2000

      You can use RAISERROR with a severity level of 11 or higher to indicate
      failure.

      Simon

        Comment

        • Justin
          #3
          Re: Explicitly fail a SQL Server Job in SQL Server 2000

          Thanks Simon. That worked.

            Comment

            Previous template Next
            Working...