Hello,
I am trying to set an email notification on job succeed or fail on SQL Jobs through SQL Database mail.
Every thing looks good in terms of setting up notification for jobs but never gets any email. While sending an test email through Database mail, it works perfectly fine.
This is what I see in Database mail logs:-
Date,Source,Severity,Log ID,Message,Process ID,Mail Item ID,Account ID,Last Modified,Last Modified By
05/25/2010 13:10:07,,Information,41522,DatabaseMail process is shutting down,5448,,,5/25/2010 1:10:07 PM,PCNATION\Administrator
05/25/2010 13:00:07,,Error,41521,1) Exception Information<nl/>===================<nl/>Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException<nl/>Message: Could not retrieve item from the queue.<nl/>Data: System.Collections.ListDictionaryInternal<nl/>TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)<nl/>HelpLink: NULL<nl/>Source: DatabaseMailEngine<nl/><nl/>StackTrace Information<nl/>===================<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)<nl/> at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o),5448,,,5/25/2010 1:00:07 PM,PCNATION\Administrator
05/25/2010 13:00:07,,Information,41520,DatabaseMail process is started,5448,,,5/25/2010 1:00:07 PM,PCNATION\Administrator
05/25/2010 12:49:36,,Information,41519,DatabaseMail process is shutting down,7300,,,5/25/2010 12:49:36 PM,PCNATION\Administrator
05/25/2010 12:39:37,,Error,41518,1) Exception Information<nl/>===================<nl/>Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException<nl/>Message: Could not retrieve item from the queue.<nl/>Data: System.Collections.ListDictionaryInternal<nl/>TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)<nl/>HelpLink: NULL<nl/>Source: DatabaseMailEngine<nl/><nl/>StackTrace Information<nl/>===================<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)<nl/> at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o),7300,,,5/25/2010 12:39:37 PM,PCNATION\Administrator
05/25/2010 12:38:01,,Error,41517,1) Exception Information<nl/>===================<nl/>Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException<nl/>Message: Could not retrieve item from the queue.<nl/>Data: System.Collections.ListDictionaryInternal<nl/>TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)<nl/>HelpLink: NULL<nl/>Source: DatabaseMailEngine<nl/><nl/>StackTrace Information<nl/>===================<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)<nl/> at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o),7300,,,5/25/2010 12:38:01 PM,PCNATION\Administrator
05/25/2010 12:38:01,,Information,41516,DatabaseMail process is started,7300,,,5/25/2010 12:38:01 PM,PCNATION\Administrator
05/25/2010 12:18:57,,Information,41515,DatabaseMail process is shutting down,5244,,,5/25/2010 12:18:57 PM,PCNATION\Administrator
05/25/2010 12:08:58,,Error,41514,1) Exception Information<nl/>===================<nl/>Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException<nl/>Message: Could not retrieve item from the queue.<nl/>Data: System.Collections.ListDictionaryInternal<nl/>TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)<nl/>HelpLink: NULL<nl/>Source: DatabaseMailEngine<nl/><nl/>StackTrace Information<nl/>===================<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)<nl/> at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o),5244,,,5/25/2010 12:08:58 PM,PCNATION\Administrator
05/25/2010 12:08:58,,Information,41513,DatabaseMail process is started,5244,,,5/25/2010 12:08:58 PM,PCNATION\Administrator
05/25/2010 12:04:51,,Information,41512,DatabaseMail process is shutting down,264,,,5/25/2010 12:04:51 PM,PCNATION\Administrator
05/25/2010 11:54:52,,Error,41511,1) Exception Information<nl/>===================<nl/>Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException<nl/>Message: Could not retrieve item from the queue.<nl/>Data: System.Collections.ListDictionaryInternal<nl/>TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)<nl/>HelpLink: NULL<nl/>Source: DatabaseMailEngine<nl/><nl/>StackTrace Information<nl/>===================<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)<nl/> at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o),264,,,5/25/2010 11:54:52 AM,PCNATION\Administrator
05/25/2010 11:37:13,,Error,41510,1) Exception Information<nl/>===================<nl/>Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException<nl/>Message: Could not retrieve item from the queue.<nl/>Data: System.Collections.ListDictionaryInternal<nl/>TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)<nl/>HelpLink: NULL<nl/>Source: DatabaseMailEngine<nl/><nl/>StackTrace Information<nl/>===================<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)<nl/> at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o),264,,,5/25/2010 11:37:13 AM,PCNATION\Administrator
05/25/2010 11:37:13,,Information,41509,DatabaseMail process is started,264,,,5/25/2010 11:37:13 AM,PCNATION\Administrator
05/25/2010 10:18:45,,Information,41508,DatabaseMail process is shutting down,7704,,,5/25/2010 10:18:45 AM,PCNATION\Administrator
05/25/2010 10:08:45,,Error,41507,1) Exception Information<nl/>===================<nl/>Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException<nl/>Message: Could not retrieve item from the queue.<nl/>Data: System.Collections.ListDictionaryInternal<nl/>TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Controller.ICommand CreateSendMailCommand(Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DBSession)<nl/>HelpLink: NULL<nl/>Source: DatabaseMailEngine<nl/><nl/>StackTrace Information<nl/>===================<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)<nl/> at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)<nl/> at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o),7704,,,5/25/2010 10:08:45 AM,PCNATION\Administrator
Any help here?
Thanks
Manish