20 pts.
 SQL Server Agent Job Creation
Hello, My self Ashish Amodia from India, I want to send Automatic mail with an attachment for that I have created job and from job that I want to open my web page automatically - I am using SQL server 2000. If u know how to open web page from job than please let me know :) Thank you

Software/Hardware used:
ASKED: May 15, 2009  4:48 AM
UPDATED: May 15, 2009  9:08 PM

Answer Wiki:
It is not recommended to call a webpage from a SQL Agent job as the SQL Agent job is a behind the scenes process, so anything that it does isn't visible to the user. You can find http_get.exe which is a command line app which can be used to get a web page. If you are simply trying to send an email with an attachment then you should look into SQL Mail and using xp_sendmail.
Last Wiki Answer Submitted:  May 15, 2009  9:08 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _