Create the generation daily and it will continue for year

i413678 · Posted: Wed Jul 12, 2006 11:21 am

Hi,

I have a requirement like the following:

I have to create the generation daily and it will continue for the whole year. and if I started today and if next month is starting i need to delete all the current months generations and start creating new generations from 1st onwards and this process continues like this............

means whenever a new month starts it has to delete previous months generations and it has to start creating generations of that new month.....means always i should have only current month generations.....

I hope requirement is clear

plz plz suggest a way............

thx in advance..................

pavan

Hanfur · Active User Joined: 21 Jun 2006 Posts: 104

I feel its better to have a job setup which delete/purge the existing GDG base and recreate GDG base with LIMIT as 31 at the month end(Monthly job).

This job should be scheduled to run on every month ends.

Then the normal daily jobs as per the schedule can create new versions from that month starting subsequently..

-Han.

Rupa.P.V · New User Joined: 04 Jul 2006 Posts: 30

Hi all,

Ya i think better to include a step to delete the GDG base and recreate the GDG base ....
And this should run in every month end.

Thanks....

i413678 · Posted: Thu Jul 13, 2006 10:46 am

Hi All,

Thank you for all your help.

pavan

sivaram.ch · New User Joined: 28 Jun 2005 Posts: 11

Here every month won't have that 31days. if we given 31 is the limit

Examp: Feb month only have 28 or 29 days then march first 3 days transactions will be in feb GDG base

How can we handle this situation.

Thanks

Hanfur · Active User Joined: 21 Jun 2006 Posts: 104

This Purge/recreate job has to be scheduled as the month end job.If it's Feb 28th or 29th's based on whether its a leap year or not your jobs has to be added to a particular group.

Most shope Schedulers and have different groupName which runs jobs on diffrent frequencies.You have to check it and have to add your job correspondigly to that group to ensure that this process happens on every month end.

-Han.

-Han.

jasorn · Active User Joined: 12 Jul 2006 Posts: 191 Location: USA

Just want to make sure the purge job is run after ALL the things from the month that will use it are complete. So it's after month end and prep for month begin.