I enabled e-mail notifications on our Azure managed backup out of SQL 2014 with this:
Use msdb
Go
EXEC smart_admin.sp_set_parameter @parameter_name =
'SSMBackup2WANotificationEmailIds', @parameter_value =
'enter_your_email_here'
and it e-mails me every 15 minutes which is driving me nuts, but
I am not familiar with very many SQL commands.
Any idea how to either disable it, or change it to only e-mail
me once every 24 hours?
It sends me this exact e-mail and nothing ever changes...
Smartadmin health check report
Datetime Instance name Storage errors Sql errors Credential errors Other errors Deleted or invalid backup file Number of backup loop Number of retention loops
Oct 27 2015 1:15PM SQL1 0 0 0 0 0 2 2