To enable email notifications in SQL Agent you will need to follow the following steps: 1. Configure Datbase Mail: create an email SMTP account and corresponding Email Profile. To do so please follow directions outlined in the blog post: "SQL Database...

In a previous post ( SQL Database Mail - Send Emails with Attachment ), we described how to attach a file to an email. There is a known bug related to this. Under certain conditions, the mail attachment will not be sent. If a mail with an attachment...

One of our customer was looking for ways to schedule a policy evaluation on multiple servers using their existing MSX/TSX infrastructure. I thought it would be better to blog an article that could help others looking for similar information Before...

Database Mail allows you to attach files in emails. Several examples are provided to show how you can do it. The article here is assumed that a SQL Database Mail profile "MailProfile1' has been created. The MailProfile1 tells Database Mail what account...

Sql Agent provides tokens to be used with T-Sql job step scripts. Tokens are names (strings) that are replaced at runtime with a value. The tokens provide a feature similar to variables in code. The tokens are described in MSDN ( http://msdn.microsoft...

The issue is related to default settings for quoted_identifier. In SSMS query window the default settings for quoted_identifier is ON. It means that the following code will work: DECLARE @Days INT SELECT @Days = 5 SELECT 'Test' , DateAdd ( "dd...

Database mail relies on .NET framework's SMTP client API to send emails. You could write a simple power shell script like this to test out if you are able to send mails using your smtp server Sample Powershell Code to send email: 1: $smtpServer...

This post demonstrates how you can have T-SQL results being sent to you in emails by using SQL Database Mail. The article here is assumed that a SQL Database Mail profile "MailProfile1' has been created. The MailProfile1 tells Database Mail what account...