Except that he is performing SELECTs..... If you are performing SELECTs... how can you determine "success" or "failure"?
On Wed, Mar 2, 2011 at 4:20 PM, crazy <[email protected]> wrote: > > 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 >
