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 '09 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 '09 at 02:24 PM

Aaron Alton gravatar image

Aaron Alton
565 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x898
x123
x13

asked: Oct 27 '09 at 02:15 PM

Seen: 1329 times

Last Updated: Feb 17 '10 at 07:16 AM