Deleting instance\jobs\Logs in Director automatically

CLOPES · Post by **CLOPES** » Fri May 31, 2013 6:57 am

Hello Everyone,

i know that using some routines, we can delete job's logs.
But is there a way to delete instances\jobs runs in the director using a keyword that is in the name of the job instead of deleting jobs manually job by job ?
Sometimes i have to delete some runs using a keyword like DC_YYYYMMDD on a job name as JcRun.DC_20130529145400.

Thanks

Carlos

chulett · Post by **chulett** » Fri May 31, 2013 7:09 am

Are you not leveraging the "Auto Purge" options?

ArndW · Post by **ArndW** » Fri May 31, 2013 7:20 am

There's nothing built-in which can do this by instance name wildcard. Either, as Craig suggested obliquely, use the auto-purge functionality or one would need to write a program which identifies the appropriate instances and then deletes log entries for those.

CLOPES · Post by **CLOPES** » Fri May 31, 2013 7:22 am

Auto Purge ?

I think i have not expressed well my needs.
I have to purge instances in the director module using a keyword used in the instance name.
Example :

if i have 60 instances by each jobs and 10 jobs, that will do 600 logs in the director.
Each instance have the establishment name and the day run.
I want to delete juste some establishment and for a specific day.
How can i do that without making it manually ?

chulett · Post by **chulett** » Fri May 31, 2013 7:39 am

CLOPES wrote:I want to delete juste some establishment and for a specific day.

I understood want you wanted, what I don't see right now why you'd "need" to do this kind of selective purge rather than just letting auto purge handle a full day or number of runs. As noted, you'd need to go under the covers and know how to delete records from hashed files to play this game.

CLOPES · Post by **CLOPES** » Fri May 31, 2013 7:50 am

The deletion will be demand by functional team and for an establishment\day.
I can't do that automatically, it's on demand.
i know it's a little weard but....

At the present time, i make it manually one by one

chulett · Post by **chulett** » Fri May 31, 2013 9:02 am

Let's confirm something - are your logs in fact in the hashed files or are they in the XMETA repository? That would depend on your ORLogging/RTLogging settings, in case you're not sure.

CLOPES · Post by **CLOPES** » Fri May 31, 2013 9:25 am

don't know.
When i do a rigth click on the instance in the director, it delete what part ?

chulett · Post by **chulett** » Fri May 31, 2013 9:54 am

What 8.x version do you have? That will dictate where you find the settings I mentioned which control where the logs live.

ray.wurlod · Post by **ray.wurlod** » Fri May 31, 2013 4:17 pm

Look near the bottom of the DSParams file in the project directory on the DataStage engine. This is where the values that determine the location of logging are stored. One of them is ORLogging. What values do these have?

ray.wurlod · Post by **ray.wurlod** » Fri May 31, 2013 4:18 pm

There is no solution that involves a keyword when the job run request is submitted.

CLOPES · Post by **CLOPES** » Mon Jun 03, 2013 2:00 am

Hello everyone,

Thanks for your feedbacks both.
I'm working on 8.5 version.
Most of the jobs are in server edition.
I don't have access to the server but when i take a log to administrator parameters, all DB2 parameters are empty.
Does it means that all logs are in Universe database ?
As i don't know enough the new version, can i delete jobs using the web admin module ?

chulett · Post by **chulett** » Mon Jun 03, 2013 6:02 am

CLOPES wrote:I don't have access to the server but when i take a log to administrator parameters, all DB2 parameters are empty.

Sorry but I'm not really sure what that means or what that has to do with job logs.

CLOPES also wrote:can i delete jobs using the web admin module ?

Jobs or job logs?

CLOPES · Post by **CLOPES** » Mon Jun 03, 2013 7:18 am

Hi chulett,

Jobs instances in the director.
Forget about my DB2 note

CLOPES · Post by **CLOPES** » Fri Jun 07, 2013 3:48 am

Hello everyone,

There is no way to delete jobs instances via a routine or another way using a keyword without doing it manually ?

Regards,

Carlos.