Querying for Jobs

You can view information on any job submitted by any user in the Administration tab.

Jobs that you personally have submitted also appear in the Job Execution section of your My Home screen.

To query for one or more jobs, enter values in the following fields:

1. Select one of the following:
   • Show results when ALL conditions are met. If selected, the system returns only jobs that meet all the conditions you specify in the fields below.
   • Show results when ANY condition is met. If selected, the system returns all jobs that meet any of the conditions you specify in the fields below.
2. Enter a value in at least one of the fields listed here to serve as a search criterion. You can enter any number of criteria.

   Range Fields. In each of the following fields you can select Equal To, Greater Than, Less Than, or Between from the drop-down list. You then enter a value in the empty field next to the drop-down list. If you select Between, you must also enter a value in the empty field on the right in the same row.

   The range fields include:

   • Submission Date. Search by the date the job was submitted. Click on the day you want in the calendar.
   • Start Date. Search by the date the job was started. Click on the day you want in the calendar.
   • Completion Date. Search by the date the job was completed. Click on the day you want in the calendar.
   • Job ID. Search by the system-generated ID for the job.

   Search Fields. These fields have the Search icon to their right. In each case, you can either enter a value directly in the field or click on the Search icon to bring up a Search screen to search for existing values.

   The search fields include:

   • Object Type. In this field you search for the job by the type of executable object that generated the job.

     Click the Search icon. In the Search screen, enter % in the empty search field and click Go. When the system returns all executable object instance types, click the Quick Select icon next to the one you want.

     Alternatively, enter the object type directly in the field from the main screen: Program, Load Set, Report Set, Workflow, or Data Mart.

     Note:

     To find a Load Set, you must enter "Loadset" not "Load Set."
   • Service. In this field, you search for the job by the service used to run the job. See Setting Up Services for information on services.

     Click the Search icon. In the Search screen, enter % in the empty search field and click Go. The system returns a list of all services as a concatenation of Service Location - Service Type - Priority. For example, where the service location is 41, the service type is PLSQL, and the job priority defined for the service is High:

     41-$SERVICETYPES$PLSQL-$JOBPRIORITIES$HIGH

     Alternatively, enter a string following the pattern shown above directly into the field on the main screen.

   • Execution User. In this field, you search for the job by the username of the person who submitted the job for execution.

     Enter the username directly in the field on the main screen.

     Alternatively, click the Search icon. In the Search screen, enter some part of the username with the wildcard character % preceding, following, or both. When the system returns all usernames that match, click the Quick Select icon next to the one you want.

   • Domain. In this field, you search for the job by the name of the Domain that contains the executable object that generated the job.

     Enter the name of the Domain directly in the field on the main screen.

     Alternatively, click the Search icon. In the Search screen, enter some part of the Domain name with the wildcard character % preceding, following, or both. When the system returns all Domain names that match, click the Quick Select icon next to the one you want.

   • Application Area. In this field, you search for the job by the name of the Application Area that contains the executable object that generated the job.

     Enter the name of the Application Area directly in the field on the main screen.

     Alternatively, click the Search icon. In the Search screen, enter some part of the Application Area name with the wildcard character % preceding, following, or both. When the system returns all Application Area names that match, click the Quick Select icon next to the one you want.

   • Work Area. In this field, you search for the job by the name of the Work Area that contains the executable object that generated the job.

     Enter the name of the Work Area directly in the field on the main screen.

     Alternatively, click the Search icon. In the Search screen, enter some part of the Work Area name with the wildcard character % preceding, following, or both. When the system returns all Work Area names that match, click the Quick Select icon next to the one you want.

3. Show All Status. Select either Yes or No. If you select No, you can specify which statuses you want to retrieve. See Job Statuses for an explanation of each status.
4. Click Go. The system displays the results of the search in the lower part of the screen. See General Job Information.
   You can click on the Job ID hyperlink for any job to see execution details for that job; see Job Execution Details.

Click Clear to remove the search criteria and the search results in order to begin a new search.