You can Use try.. catch in each sp for check its success or failure... see below..
Begin Try Begin Transaction --INSERT --UPDATE Commit End Try Begin Catch IF @@TRANCOUNT > 0 ROLLBACK End Catch On Wed, Mar 2, 2011 at 7:26 PM, littleccguy <[email protected]>wrote: > In this case, all the jobs are just SELECTS (reports), so I think -1 > is success and anything else would be a failure. Does that sound > right? > > so if (i == -1) {...} in a try catch should do it - i think. -- "People who never make mistakes, never do anything." dEv
