SQL Server Performance Forum – Threads Archive
Can we call an ASP page thru SQL Server ScheduleCan 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
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.