I would like to create a front-end for the user to maintain the schedule for the execution of their report process. Since they wont have SQL Mgmt Studio, I would like to create a front-end screen and execute a stored-proc to save the schedule of their process and have the SQL server agent execute it at the time they defined.
Is this possible? and what is the best approach?
You can certainly do this. If you use SQL Server Agent Stored Procedures, it will be pretty straightforward to perform the same calls that SSMS is making.
Not an exhaustive list, but you probably want to look at sp_add_jobschedule, sp_add_schedule, sp_attach_schedule, sp_delete_jobschedule, sp_delete_schedule, sp_update_schedule, sp_update_jobschedule, and sp_help_jobschedule.
answered Oct 27, 2009 at 02:24 PM