Filtering log sessions allows you to display only certain execution sessions in Operator, by filtering on parameters such as the user, status or duration of sessions. Sessions that do not meet the current filter are hidden from view, but they are not removed from the log.
To filter out certain sessions:
Open Operator.
Click on the Filter button on the toolbar.
Select the appropriate values for the following parameters. The settings by default select all sessions.
Session Number - use blank to show all sessions.
Session Name - use % as a wildcard. Hence "DWH%" would match any session whose name begins with "DWH".
Session's execution Context
Agent used to execute the session
User who launched the session
Status - Running, Waiting etc.
Date of execution: specify either a date From or a date To, or both.
Duration greater than a specified number of seconds
Click Apply for a preview of the current filter.
Click Ok.
Sessions that do not match these values are masked in the session list. The Filter button on the toolbar appears to be pushed in.
To deactivate the filter:
If the Filter button appears to be pushed in on the toolbar, click on this button.
The current filter is deactivated, and all sessions appear in the list.