SQL SERVER 2000 - Sending the ouput of web assistant jobs through mail as a attachment
-
Monday, January 21, 2013 9:34 PM
Hi,
I have few web assistant jobs which creates the HTML reports every day. I need to send the reports through mail once it generates the report?
Is there any option while creating the web assistant jobs?
Thanks in advance
- Moved by Kalman TothMicrosoft Community Contributor, Editor Tuesday, January 22, 2013 12:03 AM Not T-SQL.
All Replies
-
Tuesday, January 22, 2013 1:19 AMModerator
Hello,
You can configure SQL Mail and use it send the report as an attachment.
http://support.microsoft.com/kb/263556?wa=wsignin1.0
http://msdn.microsoft.com/en-us/library/aa260697(v=SQL.80).aspx
Use the xp_sendmail command to send the report.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com -
Tuesday, January 22, 2013 3:43 PM
Thanks for the reply..
Outlook express is the default mail client on the server machine. Will it supoort sql mail 2000?
i read it some where that "Outlook Express does not provide the MAPI interface necessary for SQL Mail
and SQL Agent Mail. Only Outlook provides that functionality."Is that correct?
-
Tuesday, January 22, 2013 4:11 PMModerator
Hello,
Outlook Express won’t work since it does not support mail profile, and SQL Mail requires the creation of a SQL profile.
I remember I used Outlook full edition from Office 2000 and Office 2003.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com -
Tuesday, January 22, 2013 4:53 PM
Hi,
Is there any other way to send an email other than SQL mail?
-
Tuesday, January 22, 2013 5:10 PMModerator
SQLMail, Web assistant are deprecated features. http://msdn.microsoft.com/en-us/library/cc707782(v=SQL.100).aspx
Please use DBMail instead. You can use DBMail to send email.
Here are few links that you can refer to
Thanks, Sethu Srinivasan [MSFT] SQL Server http://blogs.msdn.com/sqlagent -------------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.
-
Tuesday, January 22, 2013 5:44 PMModerator
Hello,
SQL Mail is the only option I know available on SQL Server 2000.
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com -
Tuesday, January 22, 2013 7:34 PM
Sethu, Is the DBMail option avaiable in Sql server 2000? I couldn't find the database mail option under SQl server logs in Management Studio..
-
Tuesday, January 22, 2013 7:36 PMDo you have any idea aboyt xp_smtp_sendmail? Is it going to work with SQL server 2000?
-
Tuesday, January 22, 2013 7:49 PM
Yes, xp_smtp_sendmail should work without Outlook. It has been found recently at:
http://mreschke.com/topic/167/SMTP+from+MSSQL+Procedure
RLF
- Marked As Answer by Allen Li - MSFTModerator Monday, January 28, 2013 2:10 AM
-
Tuesday, January 22, 2013 7:50 PMModerator
DBMail is not available in SQL 2000. Please consider upgrading your SQL 2000 instance to latest versions of SQL Server.
Support policy for SQL 2000 can be read from http://www.microsoft.com/en-us/sqlserver/support/support-updates.aspx
Thanks, Sethu Srinivasan [MSFT] SQL Server http://blogs.msdn.com/sqlagent -------------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.
.png)
