将DBmail安排到不同的收件人 [英] Scheduling DBmail to different recipients

问题描述

大家好，



我创建了一个SQL作业脚本，它有一个存储过程，用于向我公司的不同部门发送电子邮件。对于每个部门，SP的参数将更改。我很难为收件人的电子邮件ID提供单个脚本。据我所知，我们必须为每个部门创建不同的脚本。在这种情况下，我需要创建超过25个脚本。我们是否可以同时在一个脚本中包含所有收件人的电子邮件，SP参数将根据收件人而有所不同。任何人都可以帮助我吗？



提前感谢你...



Shanif

解决方案

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/53448390-e069-4c6d-a7f4-903cf8350d1b [ ^ ]





http：//www.sqlteam。 com / forums / topic.asp？TOPIC_ID = 166712 [ ^ ]



http://www.kodyaz.com/articles/sql-server-database-mail-sp_send_dbmail-example.aspx [<一个href =http://www.kodyaz.com/articles/sql-server-database-mail-sp_send_dbmail-example.aspx\"target =_ blanktitle =New Window> ^ ]



http://www.sqlservercentral.com/Forums /Topic494494-146-1.aspx [ ^ ]



查看此链接..让我知道你的目的是否服务......

Hi All,

I have created an SQL Job Script which has a store procedure that is used to send an email to different departments in my company. For each department, the parameter of the SP will change. I''m struggling to provide the recipient''s email id a single script. As per my knowledge, we have to create different scripts for every department. In that case, I need to create more than 25 scripts. Can we have all the recipient''s email in a single script at the same time, the SP parameter will differ based on recipients. Can any one help me?

Thanking you in advance...

Shanif

解决方案

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/53448390-e069-4c6d-a7f4-903cf8350d1b[^]


http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=166712[^]

http://www.kodyaz.com/articles/sql-server-database-mail-sp_send_dbmail-example.aspx[^]

http://www.sqlservercentral.com/Forums/Topic494494-146-1.aspx[^]

Check this links..and let me know ur purpose is served or not...

这篇关于将DBmail安排到不同的收件人的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！