DSXchange

Hi All,

I'm trying to figure out a way to remove the entries for the invocated job runs of a base job. I have searched and found out that:

1. Manual Delete
2. Clear Status File
3. Re Compile

from this POST.

But is there anyway we can automate this? Say, I want to check the status of the invocated job. If it is finished, then clear the status file or re-compile the base job. Can we somehow automate this?

Any ideas/suggestions toward this goal would be greatly appreciated.

Many thanks,
Whale.

I gave you the code. Run it.

kduke wrote:I gave you the code. Run it.

Yes. Kim. I did see the code. But you recommended against using it, which kinda scared me. Also, does this batch job remove the invocation entries based on the status of the invocated job run status?

Please advise.

Whale.

It deletes them all. You need to write something more complicated to do that. That is why I did not recommend it. It points out what to delete. You need to add more logic to figure out if a instance id is still running. I would say you want to delete old ones. Turn the Delete statements into Selects and see if you can see how to do it right.