Can we call an ASP page thru SQL Server Schedule | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Can we call an ASP page thru SQL Server Schedule

Can we call an ASP page from SQL Server? For example, The system has to send a report (which is an ASP page) automatically to top management people daily at a particular time, say 08.00pm. Regards
Ramesh
You can use SQLMail to send the results to a specified email address and with the SQLAgent scheduler you can accomplish the task. Or else if you want to copy that speicified ASP page file to a network location then you can use usual TSQL statements to copy the file and ensure the SQLAgent has required privileges to copy the file on that location. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>