Enabling the PJP Error Log Retention job

You can create a scheduled job that runs daily that deletes error logs from PJP_JobErrorLog depending on retention rules. Enabling this job helps manage disc space and enhances processing time.

The PJP Error Log Retention job, when enabled runs daily at 11 pm.

  1. In DWD Designer, click Execution > Job Manager.
  2. On the side bar, click PJP Error Log Retention.
  3. In the PJP Logs Setting screen, click Enable to define the retention policy for the PJP error logs.
    If Enable is not selected, then the PJP Error Log Retention job is disabled.
  4. To define the number of days the PJP error logs are retained, select one of these options:
    User Default
    Select this option to retain the PJP error logs for 30 days.
    Specify custom settings
    Select this option and specify a value from 1 to 365 in Delete logs that are day(s) old.
  5. Click Apply.
  6. Optionally, to verify settings run this script on SSMS.
    SELECT * FROM MD_SystemVariables WHERE VariableName LIKE '%Job Manager\PJP Error%'
    Note: You can expect these results from the query:
    • Job Manage\PJP Error Log Retention Option

      Possible values of this result is Default or Custom.

    • Job Manager\PJP Error Log Retention Custom Days

      Possible values displayed for this result are the numbers 1 to 365.