Purpose

To delete Web Service Access Log data.

Subsystem

General

This job deletes System Web Service Access Log data that exists in the database after running web services with logging enabled, which records access details in the System Web Service Access Log. For example, the interfaceExtract web service provides logging functionality.

If web services with logging enabled are accessed frequently, the log data can grow in size. Deleting the data assists with performance and database space requirements.

This job is run in Schedule mode. The number of records deleted is recorded in the Job Scheduler Run Log.

It is accessed from the Main Menu.

Parameters Tab:

• System Web Service Name - (mandatory)
• System Web Service Method Name - (optional)
• Days Old - (mandatory)
• Include Execution Status of Processing - (check box)
  

Rules/Notes:

The System Web Service Name and System Web Service Method Name parameters provide a List of Values (LOV) from which to select the required web service and web service method for the job.
Alternatively, for the System Web Service Method Name field you can use the default % value to run the job for all System Web Service Methods for the selected web service.

Note: List of values for these parameters are sourced from the S_WEB_SERVICE.S_WEB_SERVICE_NAME and S_WEB_SERVICE_METHOD.S_WEB_SERVICE_METHOD_NAME tables, respectively.

A System Web Service Method must have logging enabled for the job to be able to delete its access logs. (Currently, this functionality is only enabled for the interfaceExtract web service.)

The Days Old parameter is used to specify the number of days since the data was generated so that the job deletes records that that are as old or older than the specified number of days. The default value for this parameter is 30.

By default the Include Execution Status of Processing check box is deselected so that the job deletes System Web Service Access Log records that have an Execution Status of COMPLETED or FAILED.
If required, you can select the Include Execution Status of Processing check box so that the job deletes all System Web Service Access Log records with an Execution Status of PROCESSING.