I'm wondering if anyone can point me at some online resources that
demonstrate how to run a stored procedure against an SQL Server 2000
server at 6am each day?
Any help much appreciated!
Much warmth,
planetthoughtfulhttp://msdn.microsoft.com/library/e...tomate_4v1v.asp
--
David Portas
SQL Server MVP
--|||http://msdn.microsoft.com/library/d...p_adda_9tbk.asp
Hi All,
I need to opening up a browser page everyday at 6am. (What I am trying to do is to send an email with some formatted output everyday at 6am)
Is there anyway to achive this via SQL 05 Express?
Thanks,
Mal.
Hi,
why would you need to open a webpage every day? SQL Server's capable of sending emails itself. Another option is to create a console application that can send the mails and have it scheduled with windows task schedular to run at 6am every day.
http://support.microsoft.com/kb/312839/en-us
Grz, Kris.
|||Hi,
The reason I'd like to open up a web page is because, the template of the data is already there. With little bit of improvisation I would get it to be sending an email.
Actually, I did know (didn't know the code) it is possible to send emails from SQL 2K but not 05 Express.
My intension now is to open up the web page with a process and later kill the process. (with the help of schedular). It is not the best methods around as far as I can see, but hopefully I would be able to implement that quickly.
Thanks for the tip and the link.
Mal.
|||
Hi,
suhash:
My intension now is to open up the web page with a process and later kill the process. (with the help of schedular). It is not the best methods around as far as I can see, but hopefully I would be able to implement that quickly.
create a console application and use theHttpServerUtility.Execute method to execute the webform and capture the rendered html. No need to open a browser etc.
Grz, Kris.
|||Oh, thanks a lot.
I was thinking to open up a page...
Problem solves thanks to you again,
Cheers.
