How do I programatically schedule a DTS job

#1

Hi all,
How do I programatically schedule a job? I need to set the properties like
DTS package name, time and date in which the package should run and also
frequency of the run.

Please let me know how I can achieve this programatically.

Thanks
GS

#2

Check out the following in BOL:

sp_add_job
sp_add_jobschedule

"GS" wrote:

Quote:

Hi all,
How do I programatically schedule a job? I need to set the properties like
DTS package name, time and date in which the package should run and also
frequency of the run.

Please let me know how I can achieve this programatically.

Thanks
GS

#3

Or you could depending on what takes your fancy use SQL DMO to do the
creating of the jobs, job steps and schedules.

Allan

"Dave" <Dave (AT) discussions (DOT) microsoft.com> wrote

Quote:

Check out the following in BOL:

sp_add_job
sp_add_jobschedule

"GS" wrote:

Hi all,
How do I programatically schedule a job? I need to set the properties
like
DTS package name, time and date in which the package should run and
also
frequency of the run.

Please let me know how I can achieve this programatically.

Thanks
GS

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How do I programatically schedule a DTS job

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How do I programatically schedule a DTS job - 11-08-2005 , 03:02 AM

RE: How do I programatically schedule a DTS job - 11-08-2005 , 10:23 AM

RE: How do I programatically schedule a DTS job - 11-08-2005 , 01:41 PM