Home > IT Answers > SQL Server > How to sent SQLMAIL in SQL Server 2005, throu...
Deepanshu
35 pts.
0
Q:
How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.
SQL Server 2005, SSIS, SQL Mail, SQL Server Integration Services
How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.
ASKED: Jul 19 2008  6:06 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47070 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
In SQL Server 2005 you want to use Database mail not SQL Mail. SQL Mail is the old mail setup which uses Outlook to send the email, and works much better with Exchange than POP3. Database mail uses SMTP to send the emails.

The easiest way to send email is via the sp_send_dbmail procedure in the msdb database. This way you can pass in a large number of parameters to have it send what you need it to.

Out of the box there is no way to send an SMS message. If you cell phone has an email address you can send to that email address. Normally it's your cell phone number @ your cell provider.
Last Answered: Jul 20 2008  10:32 AM GMT by Mrdenny   47070 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   47070 pts.  |   Jul 20 2008  10:32AM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 

How to configure Database Mail in SQL Server 2005 to send mail   0 pts.  |   Dec 9 2008  9:28AM GMT

[...] Get the answer to this question: How can I send mail through an SSIS job? [...]

 
0