Clear Log of Multiple Instance jobs

avazeos · Post by **avazeos** » Wed Dec 13, 2006 5:47 am

Hi to all,
I have two multiple instance jobs that are executed daily 300 times each. That means that 600 hundrends instances are created daily in the director making it very difficult to trace it. Is it possible to delete these automatically without loosing the log records that is under the main job?

Thanks in advance

chulett · Post by **chulett** » Wed Dec 13, 2006 7:28 am

The 'official' answer is to recompile the base job, that will remove all instances of the invocation runs from the Director but not clear the log information. This can be problematical, however, if it is read only as most people have their production jobs, I would think.

Unofficially, there's been some discussion here but I don't recall if anyone came up with a viable option. I remember that issuing a 'Clear Status File' from the Director on an instance will remove it from the list but don't know off-hand how one would do that programmatically. Besides, I'm sure you'd prefer to pull the trigger once rather than 300 times.

Perhaps others will have some suggestions...

kduke · Post by **kduke** » Wed Dec 13, 2006 7:29 am

I would turn on the automatic clearing of logs after 3 runs instead of days or something like that. That will help.

I posted a SQL statement which will delete RT_STATUSnnn records using instance id. Search for this post. I will post the link if you cannot find it. I know Director slows down a lot when you have this many instances.

kumar_s · Post by **kumar_s** » Wed Dec 13, 2006 9:43 pm

without loosing the log records that is under the main job

But the log records are accumulated under main job only. The 300 instance are just the representation of it.

You may use something like

Code: Select all

DELETE RT_LOGnnn where EVAL "@ID" NOT LIKE '//%'

chulett · Post by **chulett** » Thu Dec 14, 2006 2:21 am

The OP doesn't want to clear the logs, but rather the various Invocation ID instances from the Director's display... which is why Kim suggested a script [cough] hack [cough] to remove the appropriate RT_STATUSnnn records.

kduke · Post by **kduke** » Thu Dec 14, 2006 7:14 am

Okay it is a hack. How else can you do this? The only other way is to recompile this job.

chulett · Post by **chulett** » Thu Dec 14, 2006 7:36 am

Them's the two ways I know.

kduke · Post by **kduke** » Thu Dec 14, 2006 8:32 pm

Geez, Craig they were in my downloads folder but there was no link on my tips page. There is now. I hope nobody minds me giving these out. They look pretty valuable.

chulett · Post by **chulett** » Thu Dec 14, 2006 10:24 pm

Well, they do say you can lead a horse to water, but...