delete datastage log in director

Edwink · Post by **Edwink** » Tue Mar 04, 2008 2:04 pm

hi friends,
we use invocation_id to run a job.so at the end of the day same job has run more than 10 times with different invocation_id .this creates several entries of same datastage jobs in director....
i want to delete the log entries created by the invocation _id..
does datastge have inbuilt routine? or any one faced similar issue in your poject.
your help is greatly appreciated!!!!!!!!!

Thanks
Edwin

kcbland · Post by **kcbland** » Tue Mar 04, 2008 2:29 pm

There's no delete by invocation id functionality. The auto-purge does by run or days interval only. You could figure out the SQL to do this against the log file after figuring out the internal job number. That's a lot of work, are you sure about this requirement?

chulett · Post by **chulett** » Tue Mar 04, 2008 3:44 pm

Isn't one of the 'tricks' a recompile of the base job? I don't have this issue but I seem to remember that being one of the ways to clear all those invocations from the Director.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 04, 2008 5:25 pm

Some sites have issues with compiling in a production environment.

Just out of curiosity does anyone know whether it's even possible to compile in a protected project? The site where I'm currently working does not use protected projects.

Nripendra Chand · Post by **Nripendra Chand** » Tue Mar 04, 2008 8:57 pm

Only following operations we can do in protected project:

1- Run jobs
2- Set job properties
3- Set job parameter default values

Thanks,
Nripendra

chulett · Post by **chulett** » Wed Mar 05, 2008 8:17 am

I believe that the administrator userid can compile in a protected project.

kcbland · Post by **kcbland** » Wed Mar 05, 2008 8:26 am

The original post is about purging by invocation id, which you all have ignored. The answer is no, there is no inherent mechanism for purging this way. It's either by run interval or date interval.

chulett · Post by **chulett** » Wed Mar 05, 2008 8:33 am

Ken, no one has ignored anything, you've just taken a more literal interpretation of the problem. When the OP talked about deleting log entries, but makes comments like:

at the end of the day same job has run more than 10 times with different invocation_id .this creates several entries of same datastage jobs in director.... i want to delete the log entries created by the invocation _id

Our (or at least my) assumption was their actual desire was a common one - to remove all of the invocation instances from the Director display, not necessarily remove the actual log entries.

Without Edwin actually coming back to the thread, we won't know who has the RMM stage more fired up.

Edwink · Post by **Edwink** » Wed Mar 05, 2008 10:27 am

thanks guys..

kcbland · Post by **kcbland** » Wed Mar 05, 2008 10:45 am

I guess "by the invocation id" can be interpreted differently. The "the" seemed to mean a specific invocation id rather than all. The RMM stage failed me miserably.

chulett · Post by **chulett** » Wed Mar 05, 2008 10:59 am

Well, now hold on there partner. Edwin just said 'thanks' without letting us know which little pearl of wisdom he was thanking us for. The jury is still out.