R91300B PO and Data Selection setting

Jacky Zhang

Member
Hi,

Does anyone has even run R91300B to purge the scheduler records? Any explanation of the PO and some common used data selections for that? And, do I have to run it on LOCAL? Thanx.
 
I had modified and scheduled R91300B to be submitted to logic server weekly, which the job will delete records older than 7 days.

data selection: Job with status 20 – Completed successfully.
Proc.Options: Final Mode = 1

Modification:
Add in the following at the "Initialize Section" event of Job Schedule Columner Section:
VA sec_PurgeDate=add_days([SL_DateToday],-7)
Set Selection Append Flag (<Yes>)
Set User Selection(BC Date-Updated(F91320)(UPMJ),<Less Than or Equal To>, VA sec_Purge_Date,<And>)

You can change the "-7" to your own preference. This indicate the number of days to keep the records before purge.

Hope this help.
 
Back
Top