We configured different jobs in each sever(full,diff,tlog,dbcc and rebuild \reord,history cleanup jobs).
We are getting alerts when the job is failed is as follows ::
The job failed in the server XXXXXXXX on Nov 14 2012 2:15AM.Please refer the log file for detail information.
We need to search each and evry job to find which job is failed ??.
Is it possible to get a failure alert with the job name , then it is easy to resolve the issue quickly.
I dont have much knowledge on scrpting side ...........