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 ....

more ▼

asked Oct 27, 2009 at 02:15 PM in Default

Don gravatar image

11 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest

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.

more ▼

answered Oct 27, 2009 at 02:24 PM

Aaron Alton gravatar image

Aaron Alton
575 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 27, 2009 at 02:15 PM

Seen: 1514 times

Last Updated: Feb 17, 2010 at 07:16 AM