How to capture error exception? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to capture error exception?

Hi all.
i have manage upto 10 servers. i have a script. this script check all servers job status using openrowset command. if one statement failed then allother statements are terminated. but i need contiune with error. How it is possible? Thanks
S. Ramesh
you may use RAISEERROR , refer below article for more. Regards Hemantgiri S. Goswami
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami