Creating a Custom Schedule for a DTS Package

#1

I have a DTS package that is set up (as a recurring Job Schedule) to
run every hour. I would like to "skip" the job during a small time
frame, and then restart after that time frame passes. For example,
have the job run every hour EXCEPT between 1:00 AM and 4:00 AM. I
need to do this because of other processes that are effecting the data
outside of DTS during this time frame, and if they try to execute at
the same time, it causes problems.

Is there a way to do this by configuring the scheduler? The only way
I could do this is "ugly" - create 20 Jobs that run the same package
once per day, and increment each jobs start time by 1 hour.

I would greatly appreciate any suggestions.
Thank you!

#2

Kirk,

If you schedule the job from within DTS, it creates a SQL Agent job. You
can directly change the schedules on the job to have more than one schedule
on the one job. Assuming that you run at a quarter after the hour:

Schedule 1: Run at 12:15 AM every night.
Schedule 2: Run hourly from 4:15 AM to 11:15 PM

RLF

"Kirk" <loki70 (AT) hotmail (DOT) com> wrote

Quote:

I have a DTS package that is set up (as a recurring Job Schedule) to
run every hour. I would like to "skip" the job during a small time
frame, and then restart after that time frame passes. For example,
have the job run every hour EXCEPT between 1:00 AM and 4:00 AM. I
need to do this because of other processes that are effecting the data
outside of DTS during this time frame, and if they try to execute at
the same time, it causes problems.

Is there a way to do this by configuring the scheduler? The only way
I could do this is "ugly" - create 20 Jobs that run the same package
once per day, and increment each jobs start time by 1 hour.

I would greatly appreciate any suggestions.
Thank you!

#3

Kirk,

If you schedule the job from within DTS, it creates a SQL Agent job. You
can directly change the schedules on the job to have more than one schedule
on the one job. Assuming that you run at a quarter after the hour:

Schedule 1: Run at 12:15 AM every night.
Schedule 2: Run hourly from 4:15 AM to 11:15 PM

RLF

"Kirk" <loki70 (AT) hotmail (DOT) com> wrote

Quote:

I have a DTS package that is set up (as a recurring Job Schedule) to
run every hour. I would like to "skip" the job during a small time
frame, and then restart after that time frame passes. For example,
have the job run every hour EXCEPT between 1:00 AM and 4:00 AM. I
need to do this because of other processes that are effecting the data
outside of DTS during this time frame, and if they try to execute at
the same time, it causes problems.

Is there a way to do this by configuring the scheduler? The only way
I could do this is "ugly" - create 20 Jobs that run the same package
once per day, and increment each jobs start time by 1 hour.

I would greatly appreciate any suggestions.
Thank you!

#4

Kirk,

If you schedule the job from within DTS, it creates a SQL Agent job. You
can directly change the schedules on the job to have more than one schedule
on the one job. Assuming that you run at a quarter after the hour:

Schedule 1: Run at 12:15 AM every night.
Schedule 2: Run hourly from 4:15 AM to 11:15 PM

RLF

"Kirk" <loki70 (AT) hotmail (DOT) com> wrote

Quote:

I have a DTS package that is set up (as a recurring Job Schedule) to
run every hour. I would like to "skip" the job during a small time
frame, and then restart after that time frame passes. For example,
have the job run every hour EXCEPT between 1:00 AM and 4:00 AM. I
need to do this because of other processes that are effecting the data
outside of DTS during this time frame, and if they try to execute at
the same time, it causes problems.

Is there a way to do this by configuring the scheduler? The only way
I could do this is "ugly" - create 20 Jobs that run the same package
once per day, and increment each jobs start time by 1 hour.

I would greatly appreciate any suggestions.
Thank you!

#5

Kirk,

If you schedule the job from within DTS, it creates a SQL Agent job. You
can directly change the schedules on the job to have more than one schedule
on the one job. Assuming that you run at a quarter after the hour:

Schedule 1: Run at 12:15 AM every night.
Schedule 2: Run hourly from 4:15 AM to 11:15 PM

RLF

"Kirk" <loki70 (AT) hotmail (DOT) com> wrote

Quote:

I have a DTS package that is set up (as a recurring Job Schedule) to
run every hour. I would like to "skip" the job during a small time
frame, and then restart after that time frame passes. For example,
have the job run every hour EXCEPT between 1:00 AM and 4:00 AM. I
need to do this because of other processes that are effecting the data
outside of DTS during this time frame, and if they try to execute at
the same time, it causes problems.

Is there a way to do this by configuring the scheduler? The only way
I could do this is "ugly" - create 20 Jobs that run the same package
once per day, and increment each jobs start time by 1 hour.

I would greatly appreciate any suggestions.
Thank you!

#6

Kirk,

If you schedule the job from within DTS, it creates a SQL Agent job. You
can directly change the schedules on the job to have more than one schedule
on the one job. Assuming that you run at a quarter after the hour:

Schedule 1: Run at 12:15 AM every night.
Schedule 2: Run hourly from 4:15 AM to 11:15 PM

RLF

"Kirk" <loki70 (AT) hotmail (DOT) com> wrote

Quote:

I have a DTS package that is set up (as a recurring Job Schedule) to
run every hour. I would like to "skip" the job during a small time
frame, and then restart after that time frame passes. For example,
have the job run every hour EXCEPT between 1:00 AM and 4:00 AM. I
need to do this because of other processes that are effecting the data
outside of DTS during this time frame, and if they try to execute at
the same time, it causes problems.

Is there a way to do this by configuring the scheduler? The only way
I could do this is "ugly" - create 20 Jobs that run the same package
once per day, and increment each jobs start time by 1 hour.

I would greatly appreciate any suggestions.
Thank you!

#7

Kirk,

If you schedule the job from within DTS, it creates a SQL Agent job. You
can directly change the schedules on the job to have more than one schedule
on the one job. Assuming that you run at a quarter after the hour:

Schedule 1: Run at 12:15 AM every night.
Schedule 2: Run hourly from 4:15 AM to 11:15 PM

RLF

"Kirk" <loki70 (AT) hotmail (DOT) com> wrote

Quote:

I have a DTS package that is set up (as a recurring Job Schedule) to
run every hour. I would like to "skip" the job during a small time
frame, and then restart after that time frame passes. For example,
have the job run every hour EXCEPT between 1:00 AM and 4:00 AM. I
need to do this because of other processes that are effecting the data
outside of DTS during this time frame, and if they try to execute at
the same time, it causes problems.

Is there a way to do this by configuring the scheduler? The only way
I could do this is "ugly" - create 20 Jobs that run the same package
once per day, and increment each jobs start time by 1 hour.

I would greatly appreciate any suggestions.
Thank you!

#8

Kirk,

If you schedule the job from within DTS, it creates a SQL Agent job. You
can directly change the schedules on the job to have more than one schedule
on the one job. Assuming that you run at a quarter after the hour:

Schedule 1: Run at 12:15 AM every night.
Schedule 2: Run hourly from 4:15 AM to 11:15 PM

RLF

"Kirk" <loki70 (AT) hotmail (DOT) com> wrote

Quote:

I have a DTS package that is set up (as a recurring Job Schedule) to
run every hour. I would like to "skip" the job during a small time
frame, and then restart after that time frame passes. For example,
have the job run every hour EXCEPT between 1:00 AM and 4:00 AM. I
need to do this because of other processes that are effecting the data
outside of DTS during this time frame, and if they try to execute at
the same time, it causes problems.

Is there a way to do this by configuring the scheduler? The only way
I could do this is "ugly" - create 20 Jobs that run the same package
once per day, and increment each jobs start time by 1 hour.

I would greatly appreciate any suggestions.
Thank you!

#9

Kirk,

If you schedule the job from within DTS, it creates a SQL Agent job. You
can directly change the schedules on the job to have more than one schedule
on the one job. Assuming that you run at a quarter after the hour:

Schedule 1: Run at 12:15 AM every night.
Schedule 2: Run hourly from 4:15 AM to 11:15 PM

RLF

"Kirk" <loki70 (AT) hotmail (DOT) com> wrote

Quote:

I have a DTS package that is set up (as a recurring Job Schedule) to
run every hour. I would like to "skip" the job during a small time
frame, and then restart after that time frame passes. For example,
have the job run every hour EXCEPT between 1:00 AM and 4:00 AM. I
need to do this because of other processes that are effecting the data
outside of DTS during this time frame, and if they try to execute at
the same time, it causes problems.

Is there a way to do this by configuring the scheduler? The only way
I could do this is "ugly" - create 20 Jobs that run the same package
once per day, and increment each jobs start time by 1 hour.

I would greatly appreciate any suggestions.
Thank you!

#10

On Feb 26, 2:41*pm, "Russell Fields" <russellfie... (AT) nomail (DOT) com> wrote:

Quote:

Kirk,

If you schedule the job from within DTS, it creates a SQL Agent job. *You
can directly change the schedules on the job to have more than one schedule
on the one job. *Assuming that you run at a quarter after the hour:

Schedule 1: Run at 12:15 AM every night.
Schedule 2: Run hourly from 4:15 AM to 11:15 PM

RLF

"Kirk" <lok... (AT) hotmail (DOT) com> wrote in message

news:60b4d95e-8b53-4bb3-a645-8f9f90c82f03 (AT) u69g2000hse (DOT) googlegroups.com...

I have a DTS package that is set up (as a recurring Job Schedule) to
run every hour. *I would like to "skip" the job during a small time
frame, and then restart after that time frame passes. * For example,
have the job run every hour EXCEPT between 1:00 AM and 4:00 AM. *I
need to do this because of other processes that are effecting the data
outside of DTS during this time frame, and if they try to execute at
the same time, it causes problems.

Is there a way to do this by configuring the scheduler? *The only way
I could do this is "ugly" - create 20 Jobs that run the same package
once per day, and increment each jobs start time by 1 hour.

I would greatly appreciate any suggestions.
Thank you!- Hide quoted text -

- Show quoted text -

I don't know why I didn't see that before. Thanks a lot for pointing
me in the right direction!