Lavanyasri (11/15/2012)
I don't want the error message generated by that job failure . I want only the job name with the failure alert ........
you can use dbo.sysjobhistory and dbo.sysjobs
table to see which job is failing and why
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)