Clean up unwanted jobs and objects.

murali · Post by **murali** » Mon Apr 24, 2006 6:38 am

Hi all
Is there any way to clean up the unwanted jobs from the Datastage project. Rather than manually deleting the objects like routines,jobs and table defnitions .Can any one help me.
Thanks in advance

kcbland · Post by **kcbland** » Mon Apr 24, 2006 6:39 am

How would you identify the "unwanted" objects and what do you want to do with them?

chulett · Post by **chulett** » Mon Apr 24, 2006 6:39 am

I'm curious how any automated cleanup would know what you did or did not want.

What kind of rules did you have in mind?

murali · Post by **murali** » Mon Apr 24, 2006 7:55 am

Correct me if iam wrong . I just wanted to know if there is a method like that.so that on selection of each job that is one by one we can remove un wanted objects.

kduke · Post by **kduke** » Mon Apr 24, 2006 8:27 am

I think the easiest way is to compile all jobs. Enable job adminstration in Director. Delete all jobs which do not compile. After a normal job run then all jobs in compile status are targets to be deleted. Routines are another issue.

Backup all jobs first.

kcbland · Post by **kcbland** » Mon Apr 24, 2006 9:27 am

Again, how would you want to identify them? By name? By last run date? By status? By design? By category? Then, what do you want to do to them?

ray.wurlod · Post by **ray.wurlod** » Mon Apr 24, 2006 4:56 pm

I believe murali is seeking either the RMM object or the DMNS object.

RMM = "read my mind"

DMNS = "do what I mean not what I say"

sb_akarmarkar · Post by **sb_akarmarkar** » Tue Apr 25, 2006 4:24 am

Murali,

Just think logically..how datastage will do what you want ...
You will find your answere.

Thanks,
Anupam