September 13, 2009 at 9:55 am
Hi,
I have configured database mail long back & its working fine from the start.But today after the Full backup job is done, I did not get any email. I went through the
1.Database mail->right click->view database mail log->there are no events regarding today's events.
2.Checked windows event logs, find NO information for the failure
3.Checked the error log, find NO information for the failure
below is the message from the full backup job view history.
Date9/13/2009 2:00:00 AM
LogJob History (FULL_BACKUP)
Step ID0
ServerSQL1\INS1
Job NameFULL_BACKUP
Step Name(Job outcome)
Duration00:20:48
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
Message
The job succeeded. The Job was invoked by Schedule 6 (Daily). The last step to run was step 1 (FullBackup). NOTE: Failed to notify 'DBATeam' via email.
Please advice me how to find out the reason for this failure...
September 13, 2009 at 4:32 pm
Can you send a test message? I'd be sure the profile is still valid.
September 13, 2009 at 9:58 pm
Can you send a test message? I'd be sure the profile is still valid
You want me to send a test mail to DBATeam from database mail?
September 14, 2009 at 12:01 am
hi mamata,
jus test it with ur own mail..
Right click oon database mail...Send Test E-Mail...u can check and ...search recent logs...
u may find.....
all d best
Regards
Gani
GaNeSH
September 14, 2009 at 9:51 am
hi mamata,
jus test it with ur own mail..
Right click oon database mail...Send Test E-Mail...u can check and ...search recent logs...
u may find.....
Send Test mail is working fine and I'm able to get an email. But when the job succeeds, I'm not getting the email.
After the testing the Send mail from database mail, I can see the below log from Database mail log:
Date9/14/2009 8:42:51 AM
LogDatabase Mail (Database Mail Log)
Log ID1636
Process ID5616
Last Modified9/14/2009 8:42:51 AM
Last Modified Byabc\mssqlsrv
Message
DatabaseMail process is started
and there are no events for dates 12th & 13th in database mail log!!
please advice
September 14, 2009 at 12:14 pm
Check the views in the msdb database that start with dbo.sysmail*.
September 14, 2009 at 12:56 pm
Try the following
1. Right click on SQL Server Agent --> Properties --> Alert System --> Select the Database Mail as mail system and the mail profile (do this even if it is showing the right mail system and profile)
2. If 1 doesn't resolve the issue Restart SQL Agent
3. Make sure profile is set as public
I've seen this issue when you use scripts to configure database mail.
September 14, 2009 at 3:48 pm
Hi SA,
Restarting the SQLAgent worked. But I do not know the reason behind it!!
September 15, 2009 at 7:54 am
It may have to do with the registry not updating during the setup or the restart causes the agent to go back and reload all the settings.
Out of curiosity, are you configuring database mail via scripts?
Maybe someone else can explain.
September 15, 2009 at 10:10 am
Out of curiosity, are you configuring database mail via scripts?
No, I have used Database mail wizard to configure database mail setup.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply