x

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

Don
11 1 1 1

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

1 answer: sort newest

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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x946
x129
x15

asked: Oct 27, 2009 at 02:15 PM

Seen: 1544 times

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