!!! Solution required for Scheduling Jobs at business specif
Posted: Thu Nov 20, 2003 1:26 pm
Hi All,
Need help in the area where we need to schedule the DataStage Jobs
fulfilling the business specific time lines. We at our establishment are
using DataStage Version 5.2 in which the scheduler through the Director is
not flexible enough to handle this specific scheduling requirements.
Here is how I need to schedule some of the Jobs.
1. There are some Jobs which need to be scheduled quarterly and that
too after the end of the Lockup period of that quarter. For e.g., if the
quarter for which the Job is being executed is Jan - March, then Job should
be scheduled to be executed on the 15th of May say at 02:00am in the
morning.
2. There are some Jobs which need to be scheduled yearly and the basic
requirement remains the same as in quarter execution of these Jobs that is
this Job should get executed only after the Year ends Lock up period. For
e.g., If the year ends at 31st of Dec, then Job should get executed on the
15th of Feb at 04:00am in the morning.
I would be highly obliged, if people can help me out in this area. Has any
one encountered this kind of scheduling needs earlier, if yes, then what
were the steps taken to take care of the same. Is there is external code
which needs to be executed to include the scheduling of this phantom
process. If not, then, do you have any suggestions as to how this can be
handled.
Thanks & Best Regards
Kedar Terdalkar
Need help in the area where we need to schedule the DataStage Jobs
fulfilling the business specific time lines. We at our establishment are
using DataStage Version 5.2 in which the scheduler through the Director is
not flexible enough to handle this specific scheduling requirements.
Here is how I need to schedule some of the Jobs.
1. There are some Jobs which need to be scheduled quarterly and that
too after the end of the Lockup period of that quarter. For e.g., if the
quarter for which the Job is being executed is Jan - March, then Job should
be scheduled to be executed on the 15th of May say at 02:00am in the
morning.
2. There are some Jobs which need to be scheduled yearly and the basic
requirement remains the same as in quarter execution of these Jobs that is
this Job should get executed only after the Year ends Lock up period. For
e.g., If the year ends at 31st of Dec, then Job should get executed on the
15th of Feb at 04:00am in the morning.
I would be highly obliged, if people can help me out in this area. Has any
one encountered this kind of scheduling needs earlier, if yes, then what
were the steps taken to take care of the same. Is there is external code
which needs to be executed to include the scheduling of this phantom
process. If not, then, do you have any suggestions as to how this can be
handled.
Thanks & Best Regards
Kedar Terdalkar