When you archive BEAM job results, the results are transferred from the database to file storage on the application server - specifically to the location defined on the paths tab for configuration for the BEAMARCHIVEDIR path. In the BEAM Job Monitor, the rows corresponding to the archived job results are hidden from view unless you request to display them. You can view and restore archived job results as needed using the BEAM job monitor.
To view and restore archived job results:
- In the Menu pane, under BEAM Data Manager, click BEAM Job Monitor.
- In the BEAM Job Monitor, expand the Restrict Results By section.
- If you want to narrow the list of archived job results, select the filter criteria for the results you want to restore.
- Select the Include Archives check box.
Result: The BEAM Job Monitor refreshes and an Archived column is inserted as the last column in the monitor. If job results are archived, the corresponding Archived check box is selected. The total number of job logs will increase in the job monitor grid.
- To restore archived job results, in the Process column, click the process ID corresponding to the job.
Result: The job results are transferred back to the database, and are no longer archived on the file server.
What if I don't see job log results when I view a previously archived job?
When automatically archiving job results, if you find that some job result information is getting deleted before the scheduled archive, the PeopleSoft Process Scheduler system purge process may be occurring before the Data Manager archive can occur. For example, the PS_MESSAGE_LOG table used by Process Scheduler contains the job log entries for all jobs for the application server. This includes Data Manager jobs and non-Data Manager jobs run at the BEAMSYS. The PS_MESSAGE_LOG table is also the source for the Data Manager job log rows. When PeopleSoft is installed, the Process Scheduler daily job log purge process recurrence and options are configured. The default Days Before Purging setting is 7 days, and any job logs older than 7 days will be deleted when the daily purge process is run.
Below is an example of the Process Scheduler daily job log purge:
The following Process Scheduler system purge settings show the number of days to retain the logs before purging them:
PeopleTools > Process Scheduler > System Settings
Below is the detailed process log of PRCSSYSPURGE showing the number of rows deleted from PS_MESSAGE_LOG table:
Instead of being run daily as part of Process Scheduler, the BEAM Data Manager archive process is run each time a user runs a Data Manager job. Data Manager archive also has a configuration option for the number of days to retain the job logs. For BEAM Administrators, it is on the Configuration menu.
When the Data Manager archive process is run, it creates and executes a DMS script that reads the data from PS_MESSAGE_LOG and various BEAM database tables, keyed by the process ID, and writes the data files to the application server file system. If the Process Scheduler daily job log purge process has already run for a process ID BEAM Data Manager is attempting to archive, there is no data in the PS_MESSAGE_LOG table to retrieve and that information will be lost to the archived job.
To resolve this issue, note the PeopleSoft Process Scheduler system purge settings, and then configure the BEAM Data Manager log retention setting to ensure that no data gets lost when you archive Data Manager job results.
To note the PeopleSoft Process Scheduler system purge setting:
- In the PeopleSoft Process Scheduler, find the system purge settings.
Tip: In PeopleSoft version 8.52 and 8.53, click PeopleTools > Process Scheduler > System Settings, and then click the System Purge Options tab.
- Under Run Status Options, note the number of days indicated before items (specific job statuses) are purged from the system.
To configure the BEAM Data Manager log retention setting:
- In the BEAM Data Manager menu pane, click Configuration > General.
- On the Settings tab, under Log Retention, type a number equal to one day less that the Process Scheduler purge settings. For example, if the Process Scheduler is set to purge items after 7 days, set the BEAM Data Manager log retention value to 6.