Is there any parameter I have ot add to the following to send email
EXECUTE [dbo].[DatabaseBackup]
@Databases = 'USER_DATABASES',
@Directory = N'D:\Backup\',
@BackupType = 'FULL',
@Verify = 'Y',
@CleanupTime = 48,
@CheckSum = 'Y',
@LogToTable = 'Y'
I have activated the agent to send email, created the operator to send notification, created two alert jobFailed and jobsuccessful.
No there's no parameter needed. Have you successfully sent a test email to test that database mail is correctly configured?
Yes test email is working without any issues. Wonder what else I am missing
Are there any clues in msdb.dbo.sysmail_faileditems, or indeed can you see that the email was sent in msdb.dbo.sysmail_sentitems ?
select * from msdb.dbo.sysmail_unsentitems
select * from msdb.dbo.sysmail_faileditems
select * from msdb.dbo.sysmail_sentitems
Executed the following items but did not see any error messages.
Setup the database mail, as well as backupjobs running Ola Hallengren's script:
but do not see an email sent to the specified email address after the job is completed successfully. Backup files are created but do not have a email send when the job is complete.
You've setup an alert, but how are you firing that alert?
Why not just put the email notification on the job?
19 People are following this question.
