Filtering Jobs

In large organizations, with many jobs, it is common to have operators monitor a subset of these jobs. To allow the user to just see the objects he is interested in, SAP CPS features filters and intelliSearch.

Default filters are already available:

For the job monitor:

All (non-maintenance) jobs
For next 24 hours

You can also define own filters using a subset of the conditions listed below. Each condition can have one or more values. For each value entered, conditions can be used to show or hide specific jobs.

The following conditions can be used to create customized job filters:

Where the job has no parent
Where the job is a background job
Where the job description contains specific keywords
Where the job is on a process server
Where the job is in a queue
Where the jobs remote system name contains specific keywords
Where the job is scheduled to start after X days ago.
Where the job run date is after X days ago.
Where the job end date is after X days ago.
Where the job has status X
Where the job is from a named job definition
Where the job is from a job definition whose name starts with a prefix
Where the job is from a job definition whose name contains specific keywords
Where the job belongs to an application
Where the job priority is X
Where the job is scheduled to start within the last X days or within the next Y days
Where the job is scheduled to start after date
Where the job is owned by user/role
Extend filter with user defined SQL

You can use the ANSI SQL92 standard where-clause syntax, for user defined SQL, you have to ommit the where keyword. See the Job Filter Columns section for a list of columns.

Using User Defined SQL to display all jobs with a job id above 12345 except background jobs

JobId > 12345 and Behavior <> 2

The Behavior column can be used to differentiate background jobs from others, background jobs have a behavior set to 2. You can combine the different preset and user defined clauses, so Where the job is a background job on the Include tab is equivalent to Behavior = 2.

The above example using the Where the job is a background job on the Include tab would only require the following:

[x] Where the job is a background job

JobId > 12345

Procedure

Defining a job filter

Navigate to Monitoring → Job Monitor
Choose Filter → New Filter from the context menu.
Specify a name, a description (display name), and a number of conditions that are to be met.
For each condition, specify one or more values by choosing the blue text
1. In the new window you must choose Add for each value of a condition.
2. Choose OK to close the window.
Choose Save and Close.