Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to report failure in T-SQL step in SQL job?

Author  Topic 

henrikop
Constraint Violating Yak Guru

280 Posts

Posted - 2007-05-01 : 06:09:41
I want to execute SHELL commands. This is easily done with a SQL job.

But now I want to add some logic to the steps.

For example: Only when table x has records I want to go to the next SQL-Job step else I want to report failure en execute another step.

How can I achieve this in SQLServer 2005 jobs?

Henri
~~~~
There's no place like 127.0.0.1
   

- Advertisement -