Home > IT Answers > SQL Server > SQL Server Agent Job Creation
AshishAmodia
20 pts.
Q:
SQL Server Agent Job Creation
SQL Server Agent Jobs, SQL Server Agent, SQL Server 2000, SQL Server 2000 administration
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
ASKED: May 15 2009  4:48 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
Mrdenny
49385 pts.
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • Bookmark and Share
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 Answered: May 15 2009  9:08 PM GMT by Mrdenny   49385 pts.
  •   
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _