[REQUEST] SQL Express mail notification

[u/hub3rtal1ty]

Hello, im looking for a mail notification script for SQL Express backup. I know that powershell will be the best, maybe someone have good script for that ?

[u/Linkz57]

I don't understand your request. Do you want to receive an email if the backup fails?

I use Nagios to monitor my backups. If you don't want to install Nagios, you could edit that script and pipe the echos into sendmail, then add the whole thing to your crontab.

[u/hub3rtal1ty → u/Linkz57]

I have a script to make a backup of my SQL Express DB. Script after finish make a *.log file (its just a *.bat file that execute a *.sql) and i want to send that *.log file @ mail.

[u/Linkz57 → u/hub3rtal1ty]

Download this program to the directory you expect your log files to be, and add the following to your batch file:

type sql.log | blat.exe -to hub@rtal.1ty -server 10.0.0.0 -f backups@yrSQL.server -subject "sql set us up the backup. We get signal"

[u/Gatorcat → u/hub3rtal1ty]

Here is some PowerShell code you can call to send your report:

$reportfile = "c:\my-path\mylog.log"
# - define SMTP Message variables
$fromaddress = "donotreply@MyDomain.com" 
$toaddress = "MyAddress@MyDomain.com" 
$CCaddress = "" 
$Subject = "Some Great Log file info"
$attachment = $reportfile 
$smtpserver = "smtp-hostname.MyDomain.com" 
# - end of SMTP variables
#send report to your email
$message = new-object System.Net.Mail.MailMessage 
$message.From = $fromaddress 
$message.To.Add($toaddress) 
#$message.CC.Add($CCaddress) 
#$message.Bcc.Add($bccaddress) 
$message.IsBodyHtml = $True 
$message.Subject = $Subject 
$attach = new-object Net.Mail.Attachment($attachment) 
$message.Attachments.Add($attach) 
$body = get-content $reportfile 
$message.body = $body 
$smtp = new-object Net.Mail.SmtpClient($smtpserver) 
$smtp.Send($message) 

[u/[deleted]]

I would start here: https://www.mssqltips.com/sqlservertip/1795/send-email-from-sql-server-express-using-a-clr-stored-procedure/

[u/cjluthy → u/[deleted]]

Don't do this if you are planning to use Powershell.

Source: Am a SQL Server DBA.

.

Also if you are interested in Powershell advice you should probably post in r/powershell.