Configuration of execution time of schedule DTS Pacage

#1

Hi,

I have a DTS package which is being scheduled to run at a
predefined value everyday.

Now, I would like to change the schedule time
programmatically. (I want a package to refer to some
datetime value in user-defined table.)

Is there any way to configure DTS model so that a DTS
package is executed at some configurable time?

Thanks,
Ajit

#2

DTS itself doesn't do the scheduling it is SQL Server Agent. You could
therefore use

sp_update_jobschedule

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Ajit" <ajit27 (AT) wowmail (DOT) com> wrote

Quote:

Hi,

I have a DTS package which is being scheduled to run at a
predefined value everyday.

Now, I would like to change the schedule time
programmatically. (I want a package to refer to some
datetime value in user-defined table.)

Is there any way to configure DTS model so that a DTS
package is executed at some configurable time?

Thanks,
Ajit

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

Configuration of execution time of schedule DTS Pacage

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

Configuration of execution time of schedule DTS Pacage - 09-18-2003 , 05:59 AM

Re: Configuration of execution time of schedule DTS Pacage - 09-18-2003 , 06:05 AM