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.

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.

The job deletes log entries from the following tables:

• S_WS_ACCESS_LOG table - contains log entries from all web services, and
• S_WEB_SERVICE_ACCESS_LOG table - contains log entries from the interfaceExtract web service only.
  (Note: It is expected that this function will be removed after Release 18.1.)
  

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

This form 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.

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 as or older than the specified number of days. The default value for this parameter is 30.

Include Execution Status of Processing check box:
This parameter only applies to the interfaceExtract web service. It is ignored for all other web services.
By default the check box is deselected so that the job deletes System Web Service Access Log records from the S_WEB_SERVICE_ACCESS_LOG table, 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 from the S_WEB_SERVICE_ACCESS_LOG table, with an Execution Status of PROCESSING.