How can I clear job log with DSJOB or using some routine?

[igorbmartins]

Guys, I would like to know how I can clear job log with DSJOB or using some routine. It is possible? I have a big sequence and its log is very long. In this sequence there is an infinity loop and running during 23 hours. This sequence only start others jobs/sequences so its log is not important to me, but the others log is very important. In DataStage Administrator I configured the Auto-purge Up to previous (job runs) with 5.

Thanks.

[dinagiza]

First, if you want to clear the log only once, you can do it from the DS Director.
Where do you store you logs? In the repository or Universe?

[ray.wurlod]

It's not possible with any dsjob option to clear a job log.

You could create a server job or a routine called from a sequence to purge the log, and run that from dsjob.

(I'm pretty certain there's code somewhere on DSXchange for that routine.)

[chulett]

If your logs are stored in the 'Universe' repository:

CLEAR.FILE RT_LOGnnnn

(where 'nnnn' corresponds to the internal job number of this job) will essentially truncate the log. Purge criteria will more than likely need to be re-established after that.