开发者

how to send an email on a condition when executing a job?

开发者 https://www.devze.com 2023-02-27 15:27 出处:网络
I\'m running sql server 2005.I want to create a step in a job which executes a stored procedure, gets a result from it, and after performing a check on it, send an email.I\'ve s开发者_StackOverflowet

I'm running sql server 2005. I want to create a step in a job which executes a stored procedure, gets a result from it, and after performing a check on it, send an email. I've s开发者_StackOverflowet up Database Mail under Management and tested it and it works fine. I just don't know what the command is to send an email. Can somebody help me with this?

Thanks

Riz


You need EXECUTE msdb.dbo.sp_send_dbmail

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号