| Author |
Message |
Marley777
Group memberships:
Premium Members
Joined: 27 Jan 2004
Posts: 148
Points: 1306
|
|
| DataStage® Release: 8x |
| Job Type: Parallel |
| OS: Unix |
|
Hi, how can I run the same sequencer over and over daily? For example a sequencer will need to be schedued so that it runs hourly Monday through Friday between 6:AM and 11:PM. The DataStage scheduler in director is limited.
Thanks for your help.
|
|
|
|
|
|
ray.wurlod
Participant
Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group
Joined: 23 Oct 2002
Posts: 41076
Location: Canberra, Australia
Points: 228937
|
|
|
|
|
|
|
You can create a parent sequence that looks after the loop within a day, and schedule this parent sequence once per weekday.
|
_________________
Zenith Solutions (Australia) Pty Ltd
-- from obscurity to
clarity
|
|
|
|
|
Marley777
Group memberships:
Premium Members
Joined: 27 Jan 2004
Posts: 148
Points: 1306
|
|
|
|
|
|
|
Hi Ray, thanks for responding, can you please elaborate.
|
|
|
|
|
|
kris007
since March 2006
Group memberships:
Premium Members
Joined: 24 Jan 2006
Posts: 1088
Location: Riverside, RI
Points: 7446
|
|
|
|
|
|
You need to create a Job Sequence lets say A with a Start Loop, Job Activity and End Loop. The Counter in the Start Loop should be set how many times you want the job to run. Now, you need to create another Job Sequence(Master/Parent Sequence) with Job Sequence A in it and schedule the Master Sequence once per week day as Ray mentioned.
Hope that helps.
|
_________________
Kris
Where's the "Any" key?-Homer Simpson
|
|
|
|
|
chulett
since January 2006
Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group
Joined: 12 Nov 2002
Posts: 28935
Location: Denver, CO
Points: 149513
|
|
|
|
|
|
|
The "DataStage scheduler" is simply an interlude to cron. There's nothing stopping you from doing an "Add to schedule" for every hour in that range except that it would be rather tedious. Don't recall ...
|
_________________
-craig
And as in uffish thought he stood, the Jabberwock, with eyes of flame,
Came whiffling through the tulgey wood, and burbled as it came!
|
|
|
|
|
Marley777
Group memberships:
Premium Members
Joined: 27 Jan 2004
Posts: 148
Points: 1306
|
|
|
|
|
Marley777
Group memberships:
Premium Members
Joined: 27 Jan 2004
Posts: 148
Points: 1306
|
|
|
|
|
chulett
since January 2006
Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group
Joined: 12 Nov 2002
Posts: 28935
Location: Denver, CO
Points: 149513
|
|
|
|
|
|
|
On the subject of sleeping, unless your job runs very very quickly it can't afford to sleep for the full 60 minutes, if you do you will slowly start creeping past your straight-up hour start time.
...
|
_________________
-craig
And as in uffish thought he stood, the Jabberwock, with eyes of flame,
Came whiffling through the tulgey wood, and burbled as it came!
|
|
|
|
|
|
|
