August 27, 2014 at 7:51 pm
Hello,
When I start SQL Server Agent it's shutting down minute after starting .
I tried to set Alerts to send email. After I configured Database Mail ,
I was able to send test email , however after that SQL Server Agent
started to misbehave.
Please help
August 28, 2014 at 12:20 am
jeninrshik (8/27/2014)
Hello,When I start SQL Server Agent it's shutting down minute after starting .
I tried to set Alerts to send email. After I configured Database Mail ,
I was able to send test email , however after that SQL Server Agent
started to misbehave.
Sounds wiered.
Did you check error log and event logs ? Any useful info in that ?
Does it work fine if you remove the alert you configured. ?
Smit.
August 28, 2014 at 1:41 am
I'm a noob 🙂 to SQL , so please don't judge me to harsh
When I deleted alerts, SQL server stays on 🙂 , can I send notification throw TSQL and not use alerts from SQL server Agent ?
Error Log :
Date,Source,Severity,Message
08/28/2014 09:50:24,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
08/28/2014 09:50:24,,Warning,[260] Unable to start mail session.
08/28/2014 09:50:24,,Warning,[474] Unable to refresh Database Mail profile . (reason: No mail profile defined)
08/28/2014 09:50:23,,Information,[129] SQLSERVERAGENT starting under Windows NT service control
08/28/2014 09:50:23,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent
08/28/2014 09:50:13,,Information,[432] There are 12 subsystems in the subsystems cache
08/28/2014 09:50:13,,Information,[339] Local computer is FILM running Windows NT 6.1 (7601) Service Pack 1
08/28/2014 09:50:13,,Information,[310] 2 processor(s) and 3581 MB RAM detected
08/28/2014 09:50:13,,Information,[103] NetLib being used by driver is DBNETLIB; Local host server is
08/28/2014 09:50:13,,Information,[102] SQL Server ODBC driver version 11.00.2100
08/28/2014 09:50:13,,Information,[101] SQL Server FILM version 11.00.2100 (0 connection limit)
08/28/2014 09:50:13,,Information,[000]
08/28/2014 09:50:13,,Information,[495] The SQL Server Agent startup service account is NT Service\SQLSERVERAGENT.
08/28/2014 09:50:13,,Information,[100] Microsoft SQLServerAgent version 11.0.2100.60 (x86 unicode retail build) : Process ID 3792
08/28/2014 04:20:57,,Error,[LOG] Failed to send notification email to operator 'Evgeny' for alert 'FileAutogrowth'
08/28/2014 04:20:57,,Error,[441] SQLiMail API send mail failure (reason: System.NullReferenceException: In an instance of Object reference not set to an object.Microsoft.SqlServer.Management.SqlIMail.Server.Common.MailClient.SendMail(String strRecipientsToList<c/> String strRecipientsCcList<c/> String strSubject<c/> String strBodyText<c/> MessageType messageType<c/> MailPriority priority<c/> String sensitivity<c/> String fromAddress<c/> String replyTo)<nl/> ? Microsoft.SqlServer.Management.SqlIMail.Server.Common.MailClient.SendMail(String strRecipientsToList<c/> String strRecipientsCcList<c/> String strSubjec)
08/28/2014 04:20:46,,Error,[440] SQLiMail send mail failure (reason: )
08/28/2014 04:20:46,,Error,[298] SQLServer Error: 14607<c/> profile name is not valid [SQLSTATE 42000]
08/28/2014 04:20:25,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
08/28/2014 04:20:25,,Warning,[260] Unable to start mail session.
08/28/2014 04:20:25,,Warning,[474] Unable to refresh Database Mail profile . (reason: No mail profile defined)
08/28/2014 04:20:25,,Information,[129] SQLSERVERAGENT starting under Windows NT service control
08/28/2014 04:20:24,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent
08/28/2014 04:20:14,,Information,[432] There are 12 subsystems in the subsystems cache
08/28/2014 04:20:13,,Information,[339] Local computer is FILM running Windows NT 6.1 (7601) Service Pack 1
08/28/2014 04:20:13,,Information,[310] 2 processor(s) and 3581 MB RAM detected
08/28/2014 04:20:13,,Information,[103] NetLib being used by driver is DBNETLIB; Local host server is
08/28/2014 04:20:13,,Information,[102] SQL Server ODBC driver version 11.00.2100
08/28/2014 04:20:13,,Information,[101] SQL Server FILM version 11.00.2100 (0 connection limit)
08/28/2014 04:20:13,,Information,[000]
08/28/2014 04:20:13,,Information,[495] The SQL Server Agent startup service account is NT Service\SQLSERVERAGENT.
08/28/2014 04:20:13,,Information,[100] Microsoft SQLServerAgent version 11.0.2100.60 (x86 unicode retail build) : Process ID 6924
so my guess is that a problem with Database Mail that i configure or May be some issues with security restriction
Thank you a lot Smit.
August 29, 2014 at 8:45 am
Error show 'Unable to refresh Database Mail profile . (reason: No mail profile defined)'. Did you configure a database mail profile. Please follow the link on directions http://msdn.microsoft.com/en-us/library/ms187605.aspx#SSMSProcedure
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply