DSXchange

We have datastage log auto-purge set at project level from dsadmin. It is set to purge in 5 days.. But when I look at log it contains everything from day-1, so I suspect this auto-purge does not work..
If anyone could give me some pointer where to look to fix this..

Off the top of my head I believe that the change you made will only affect new jobs created in that project.

The old jobs in your project would not have had their auto-purge changed.

Tim

Only when a job runs does the log get purged. If you only run a job once a month, but its purge is daily, it will only purge when the job runs. There's no "purge" daemon to clean up logs daily - it's the responsibility of the job to maintain its own log.

Setting the project purge setting means that any newly created, copied, or imported jobs will have that setting.

And it isn't really set to purge "in 5 days". It's set to keep at most five days in the log, and as Ken notes, will purge anything over 5 days old only after the job runs successfully. That's key to note as well, if a job completes with Warnings or Aborts the auto-purge will not be triggered.

from archive/prev posting, I saw how to programmatically set the auto-purge property on each jobs.

Would the script work in read-only env?
In our prod env, the DS projects are protected & all objects are read-only.

I believe so... couldn't hurt to try. It will either work or not work. At worst case, unprotect the project, make the change and then protect it again.