Checking Job Status

  To check the execution status of jobs:

1. Select Tools, then Job Console.

   By default, all jobs are displayed.

   For each job, this information is displayed:

   • Job ID: The sequential number that the database generates for each started job.

   • Job Type: Business Rule, Ruleset (for Calculation Manager), Sequence (for Business Rules), Clear Cell Details, Copy Data, or Push Data.

   • Job Name: The business rule, sequence, or ruleset's name. To expand rulesets to see the business rules and rulesets they include, click . Planning automatically assigns a name to Clear Cell Details and Copy Data operations.

   • User Name: The name of the user who launched the job.

   • Start Time: When the job was started.

   • End Time: If the job was completed or ended in an error, the time the job ended.

   • Run Status: Processing, Completed, or Error.

2. To filter which jobs are displayed, from Filter Criteria, select which jobs to view. To display jobs:

   • Executed by a specified user: Select User and enter the user's name in the User Name text box.

   • By their type: Select Job Type. Then from Select Job Type, select Business Rule, Ruleset or Sequence, Clear Cell Details, Copy Data, or Push Data.

   • By their status: Select Run Status. Then from Select Run Status, select Status Processing, Status Completed, or Status Error.

   • Executed since a specified day and time: Select Start Time. Then click and, from the calendar, select the job's start time, and then click OK.

   • That completed executing before or by a specified day and time: Select End Time. Then click and, from the calendar, select the job's end time and then click OK.

   • By their name: Select Job Name and in the Job Name text box, enter its name.

   To again display all jobs, select None, the default.

3. Click Go.

   The Job Console displays the jobs matching your selection criteria.

4. Optional: Use the navigation aids at the page bottom to move around a long list of jobs.

5. To view this job information, under Run Status, click the links to the log files:

   • For Clear Comments: the dimensional intersection of the cleared details

   • For Copy Data: the dimensional intersection for the copied data

   • Cell-level Document: the dimensional intersection for the cleared documents

   • For business rules, sequences (for Business Rules), and rulesets (for Calculation Manager): the application, plan type, and runtime values. If the rule generated an error, a text box displays the error.

     Note:

     Information on rulesets in Hyperion Calculation Manager display as expandable hierarchies, and status is displayed individually for each embedded rule and ruleset as they are processed. However, sequences in Business Rules are not expandable, and status reflects the status of the entire sequence.

     Tip:

     For administrators only: Because checking for runtime values for many users consumes system resources, to improve performance, you can turn off this function by selecting Administration, then Application, then Properties, then Application Properties tab, and adding the property CAPTURE_RTP_ON_JOB_CONSOLE and setting its value to FALSE. See the Oracle Hyperion Planning Administrator's Online Help.

6. Optional. For administrators only: To remove selected jobs from the list and to remove their job records from the database, click Delete.

   You cannot delete jobs that are processing, only jobs that are completed or have errors.

   To remove all jobs from the list and remove their job records from the database, select the check box left of the header Job ID.