Send Mail:

DECLARE @subject VARCHAR(100)
SET @subject = ‘Test email. Sent time: ‘
+ CAST(GETDATE() AS VARCHAR(20))

EXEC msdb.dbo.sp_send_dbmail @profile_name = ‘DBMailProfile1′,
@recipients = ‘roman@hotmail.com’, @body = ‘It worked!!!’,
@subject = @subject
Since there are so many paramet

USE msdb

SELECT * FROM sysmail_allitems
ORDER BY mailitem_id DESC

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s