question

Don avatar image
Don asked

Changing SSIS Job Schedule outside of SSMS

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?

Thanks ....

ssisssmsschedule
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Aaron Alton avatar image
Aaron Alton answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.