exec master.dbo.xp_sendmail
@recipients ='myasin@clash-media.com',
@subject = 'testing SQL Server Emails',
@message = 'Free space on Z Drive has dropped below 2 Gigabyte'
will get error message if on 64-bit version:
"SQL Mail does not work with the 64-bit version of SQL Server"
Instead Can use:
Profile Name is the setting in:
[database] -> Management -> Database Mail -> Configure Database Mail
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'SQLServerDatabaseMailProfile',
@recipients = 'muhammad.yasin@clash.com',
@body = ' is scheduled to be renewed in 120 days - GET TO WORK!',
@subject = 'testing by yasin'
@recipients ='myasin@clash-media.com',
@subject = 'testing SQL Server Emails',
@message = 'Free space on Z Drive has dropped below 2 Gigabyte'
will get error message if on 64-bit version:
"SQL Mail does not work with the 64-bit version of SQL Server"
Instead Can use:
Profile Name is the setting in:
[database] -> Management -> Database Mail -> Configure Database Mail
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'SQLServerDatabaseMailProfile',
@recipients = 'muhammad.yasin@clash.com',
@body = ' is scheduled to be renewed in 120 days - GET TO WORK!',
@subject = 'testing by yasin'
No comments:
Post a Comment