!!! Solution required for Scheduling Jobs at business specif

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

!!! Solution required for Scheduling Jobs at business specif

Post by admin »

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
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

!!! Solution required for Scheduling Jobs at business specif

Post by admin »

DataStage's scheduler is just an interface to cron on
Unix and AT on NT. So, therefore, any robust
scheduling needs to be handled either a custom
scheduling solution or a shrink-wrapped third party
scheduler. I suggest you have the state of Florida
purchase a shrink-wrapped third party scheduler.

Good luck!
-Ken


--- "Terdalkar, Kedar R."
wrote:
> 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


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

!!! Solution required for Scheduling Jobs at business specif

Post by admin »

Thanks a lot for your suggestion Kenneth ... we have found a work around to
this problem ...

Thanks & Regards
Kedar

-----Original Message-----
From: Kenneth Bland [mailto:kcbland_2000@yahoo.com]
Sent: Thursday, November 20, 2003 3:05 PM
To: datastage-users@oliver.com
Subject: Re: !!! Solution required for Scheduling Jobs at business
specific in tervals !!!

DataStage's scheduler is just an interface to cron on
Unix and AT on NT. So, therefore, any robust
scheduling needs to be handled either a custom
scheduling solution or a shrink-wrapped third party
scheduler. I suggest you have the state of Florida
purchase a shrink-wrapped third party scheduler.

Good luck!
-Ken


--- "Terdalkar, Kedar R."
wrote:
> 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


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked