Job sequencer problem
Moderators: chulett, rschirm, roy
Job sequencer problem
Is there any way that I can manipulate the individual activities in a job sequencer to execute at different intervals?
Please help.
And if there's any further information required,do revert.
Regards,
Kumarjit.
Please help.
And if there's any further information required,do revert.
Regards,
Kumarjit.
Pain is the best teacher, but very few attend his class..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thank Heavens that I finally get to have the MASTER of the Business reply on my post...
But Ray, "No" as in?
Do you mean to say that if there are three activities in a sequencer, and if I require to configure the second activity not to run on the last day of every month, I wont be able to do so.
Please clarify if I'm right.
Regards,
Kumarjit.
But Ray, "No" as in?
Do you mean to say that if there are three activities in a sequencer, and if I require to configure the second activity not to run on the last day of every month, I wont be able to do so.
Please clarify if I'm right.
Regards,
Kumarjit.
Pain is the best teacher, but very few attend his class..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Note that what Craig suggested is not "manipulating individual activities". His approach is to use custom triggers to determine whether the activities run at all. This is a valid approach. But, again, your overall requirement remains vague. You'll need to tighten your specification before you even look at implementing it using a DataStage sequence.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Correct - my reply was specific to the hypothetical, hoping at some point you'll come back and clarify exactly what it is you need to do or meant to ask. Still though, nothing can be 'manipulated' per se - you design the sequence to run or not run individual activities as needed.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks to Craig for giving me a direction to walk towards.
And pardon me for the usage of inappropriate English as in "manipulate", because all I wanted to know is that if there's any way that I can skip/not let a constituent activity in a job sequencer to get executed on a specific day/time.
I will try and run across as much help I can find over the net, but I still would appreciate if any one comes with any.
Regards,
Kumarjit.
And pardon me for the usage of inappropriate English as in "manipulate", because all I wanted to know is that if there's any way that I can skip/not let a constituent activity in a job sequencer to get executed on a specific day/time.
I will try and run across as much help I can find over the net, but I still would appreciate if any one comes with any.
Regards,
Kumarjit.
Pain is the best teacher, but very few attend his class..
One solution would be a custom routine, one that checks the current date/time for the conditions you require and then passes back true or false. Your triggers coming from the Routine Activity stage can use that answer to know what to do (or not do) next.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
@Craig: I'm trying to use a Nested Condition stage and set up a Custom Trigger expression which checks whether the @DAY is equal to the last day of the current month.
But the challenge here is I'm not being able to use any Datastage System variable like @DAY or @MONTH or @DATE to get the last day of the current month.
Is this possible by any means?
Please suggest.
Regards,
Kumarjit.
But the challenge here is I'm not being able to use any Datastage System variable like @DAY or @MONTH or @DATE to get the last day of the current month.
Is this possible by any means?
Please suggest.
Regards,
Kumarjit.
Pain is the best teacher, but very few attend his class..
Me, I'd still write a routine. [shrug]
So - what's your WORKAROUND? In my mind there's nothing broken here that needs to be "worked around" so it's either resolved or it isn't. The fact that there are multiple resolutions and you may not have implemented the one you wanted doesn't make it a work around.
So - what's your WORKAROUND? In my mind there's nothing broken here that needs to be "worked around" so it's either resolved or it isn't. The fact that there are multiple resolutions and you may not have implemented the one you wanted doesn't make it a work around.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why can't you use @DAY? This is the day portion (as a number) of the current date. It's a system variable.
You might make use of (@DAY + 1) = 1 to detect the last day of the current month.
You might make use of (@DAY + 1) = 1 to detect the last day of the current month.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.