(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?You can use RAISERROR with a severity level of 11 or higher to indicate
failure.
Simon|||Thanks Simon. That worked.
Monday, March 19, 2012
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?You can use RAISERROR with a severity level of 11 or higher to indicate
failure.
(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?You can use RAISERROR with a severity level of 11 or higher to indicate
failure.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment