 | |
Creating a Custom Schedule for a DTS Package
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Creating a Custom Schedule for a DTS Package -
02-27-2008
, 08:16 AM
|
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 - |
me in the right direction!
#12
| |||
| |||
|
|
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 - |
me in the right direction!
#13
| |||
| |||
|
|
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 - |
me in the right direction!
#14
| |||
| |||
|
|
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 - |
me in the right direction!
#15
| |||
| |||
|
|
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 - |
me in the right direction!
#16
| |||
| |||
|
|
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 - |
me in the right direction!
#17
| |||
| |||
|
|
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 - |
me in the right direction!
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.