Force Job as Successful

Question

Post reply

Force Job as Successful

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

cherish.j.wang SSC Eights! Points: 808 More actions · Answer 1

As far as i know, there is no any way to force the job success. maybe you have to do it by your logical side.

LutzM SSC Guru Points: 107049 More actions · Answer 2

I think you could wrap the original call into a TRY ... CATCH block and don't raise an error at the CATCH section.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

padhis SSCommitted Points: 1762 More actions · Answer 3

I also using same to get rid of repeated notification.

spaghettidba SSC Guru Points: 105732 More actions · Answer 4

Paul Bukowski (1/15/2012)
For now, I manually create a new dummy step (last step) in the job, like say select getdate() and then execute that step, which will force the job to be successful.

It works, but it's not a "clean" technique. Be sure to document it properly.

My vote goes to TRY/CATCH.

-- Gianluca Sartori