How to schedule stored procedure from the web?

We need to allow users to set filters and schedule to run their queries daily, weekly, monthly online (ASP.NET)? What is the best way to do it if there is any?

There is a way.
First schedule a stored procedure using Enterprise Manager.
Second right click on the new job, select all tasks, select generate SQL script.
That will give you the script necessary to schedule a job.
In order for parameters to be passed to a proc without any user interaction, you will have to store the users filters in another table.

The direct connection from your pc to the MS Sql database is not possible by using local database manager, such as Enterprise Manager. You need to use the appropriate panel or possible tools via scripting from your own domain.





is it possible to schedule a stored procedure using asp ?

spicycute02 Please take the time to read our forums FAQs before posting



Don't resucitate old threads, please create your own.



--> Thread Closed