Example queries - syncsort_capacity_management - Latest

1. A Single Rule to choose all Jobs that start with a J with a single Expression to choose a particular Job Type.

    

   This will return all the Jobs where the Job Number has a first character of 'J'.

    

2. Single Rule with a Job Name and a Job Type Expression.

    

   This will return all the Jobs where the Job Number has a first character of 'J' AND a Job name that starts with an 'A'

    

3. Single Rule with a Job Name and a Job Type Expression.

    

   This will return all the Jobs where the Job Number has a first character of 'J' AND a Job name that starts with a 'QCP'.

    

4. Single Rule with a Single Rule with a Job Name and a Job Type Expression where the Wildcard contains conditions for any single character and single character in a list.

    

   This will return all the Jobs where the Job Number has a first character of 'J' AND a Job name that:

   • Starts with a 'QCP'

   • Has a 0,1,2, or 3 at the 6th character

   • Has a 'D' at the 8th character

   • Has no letters after the 'D'

    

5. Two Rules each providing a different set of Jobs to the Application.

 

This returns a Job that meets one of the two criteria below:

• Started Tasks that start 'CICS'

• Started Tasks that start 'ACSPR' and have a '5' at the 7th character