Scheduling R01131P Message Purge

Roger Miller

Member
I would like to set up the message purge R01131P in the scheduler, to run automatically every night, and delete messages that are over 100 days old. The UBE has processing options that require a date range, and no data selection criteria. How do I set this up so I don't have to chnage the processing option every day.

We are running Xe, SP22_X1, NT Oracle.

Thanks
Roger
 
Modify the program to go off a computed date range of < Today - 100 days.
 
Add a version and go into design version. Modify the event rules to ignore the processing options and set the user date selection to < today - 100.
 
Sorry. I corrected my last message to read:

Add a version and go into design version. Modify the event rules to ignore the processing options and set the user date selection to < today - 100.
 
I know its been a while - but I was just looking for a way to do this. I wanted to have a scheduled job that deleted all messages >1 year old.

1. Make a copy of R01131P - I called mine R5501131P
2. Modify the hidden section "Address Book..."
3. In the Initialize Section - the following :
0001 If PO PurgeByDate is equal to "1"
0002 If PO ThruDate is equal to <Blank>
0003 \\ PO ThruDate = date_today() <-- old line
0003 PO ThruDate = add_days(date_today(),-365)
0004 End If
0005 If PO FromDate is equal to <Blank>
0006 PO FromDate = date_today( )
0007 End If
0008 End If
4. Save this, check it in, then create a version with "blank" in the through date, and "1/1/1990" in the from date
5. Schedule this whenever you want to purge your messages !

Hope that helps !
 
Back
Top