InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 12:38:36 GMT20http://www.sqlservercentral.com/Forums/Topic1385020-146-1.aspx[quote][b]Lavanyasri (11/15/2012)[/b][hr]I don't want the error message generated by that job failure . I want only the job name with the failure alert ........[/quote] you can use [code="sql"]dbo.sysjobhistory and dbo.sysjobs [/code]table to see which job is failing and whyThu, 15 Nov 2012 03:28:12 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1385020-146-1.aspxYou get an email which contains the below[code="other"]Job Name = Staging_Circle.MergeResourceToProcessWithResources -------------------------------------- Step name = Circle.MergeResourceToProcessWithResources DB Name = Staging_Database Run Date = Nov 14 2012 11:08AM Error = Unable to connect to SQL Server 'SQL01\INSTANCE01'. The step failed. Command = EXEC Circle.MergeResourceToProcessWithResources[/code]You can obivously just go into the procedure and strip out the call to the part which gets the error and command, or use the script as a base point and create your own. Thu, 15 Nov 2012 03:16:20 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1385020-146-1.aspxHi Anthony, Thanks for the quick response ..I don't want the error message generated by that job failure . I want only the job name with the failure alert ........Thu, 15 Nov 2012 03:06:42 GMTLavanyasrihttp://www.sqlservercentral.com/Forums/Topic1385020-146-1.aspx[url]http://www.sqlmag.com/article/tsql3/have-sql-server-email-you-error-messages-generated-by-job-failures[/url]You will need to add a step to the end of every job which is got to by the on failure action of the other steps in the job but this is what we use to get job failure emails.Thu, 15 Nov 2012 02:39:19 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1385020-146-1.aspxHi Team,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 ::[b]The job failed in the server XXXXXXXX on Nov 14 2012 2:15AM.Please refer the log file for detail information.[/b]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 ...........Thanks,LavanyaThu, 15 Nov 2012 02:33:16 GMTLavanyasri