Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > sql server > answers

Explicitly fail a SQL Server Job in SQL Server 2000

Justin
Guest
  
Posts: n/a
#1: Jul 23 '05
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?

Simon Hayes
Guest
  
Posts: n/a
#2: Jul 23 '05

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
Justin
Guest
  
Posts: n/a
#3: Jul 23 '05

re: Explicitly fail a SQL Server Job in SQL Server 2000

Thanks Simon. That worked.
Closed Thread

« previous question | next question »

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,510 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved