Job Cleanup

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
oacvb
Participant
Posts: 128
Joined: Wed Feb 18, 2004 5:33 am

Job Cleanup

Post by oacvb »

Hi,

We created a sequencer (Load_Process_Data) which calls 2 jobs. All (Sequencers & Jobs) are compiled and everything is ok. When we trigger the sequencer, we were running the instance of the sequencer(Load_Process_Data_TimeStamp Ex:- Load_Process_Data_20050522_220323). In Data Stage director, Instance and the original sequencer will be displayed. When days goes on, the number of instance will increase. Now we need to cleanup the instance of the sequencer on every week. How can we do this?

Regards,
O.A.C.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Discussed Several times.
The response from my support call to Ascential is that there are 3 manual methods to delete invocation entries from the Status View in Director:

1. Manual Delete
2. Clear Status File
3. Re Compile
Do a search you can find some interesting routines developed by our website toppers.

viewtopic.php?t=89607&postdays=0&postor ... g&start=15

viewtopic.php?t=95603&highlight=multiple+instance+log
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply