Hi Friends,
I am running a SQL Agent job which comprises an SP call. In side of the SP, try catch i have used. when any error occured, the control is shifting to catch block and indicates the SP execution is success and eventually the job step and totally the job is success when i look at the history. Now i would like to see the job history as failed when the control in side the SP is going to catch block. How to get this functionality. Could any one of you help me in this regard.
Thanks in advance for your help.
Thanks & Regards,
Venkat.