force job step to fail based on select query?
-
I would like to create a SQL job which runs a select query to watch for certain data flags - can I base the success or failure on the data returned? I know I could do this with DTS/ActiveX, but it seems like there should be a way to do this with a job. Any ideas?
Thanks
Jeff
-
Might be sneaky but...
If not exists (Select flag where..)
begin
select 1/0
--should fail, make this step exit the job on failure.
end
else
begin
--don't do anything>> will go to next step
end
or you could actually control the flow from there and call the appropriate sp as needed.
-
See if this can help you
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=9576
Regards,Yelena Varsha
-
Thanks folks - I ended up going with RAISERROR (duh....forgot about it) but I love the select 1/0 answer!! Very clever.
-
Thanx
.HTH.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply