Checking Job Status

On the Job Console page, you can check the status of these job types: Business Rules, Ruleset, Sequence, Clear Cell Details, Copy Data, and Push Data.

Notes:

  • You can be notified by email when a launched job is in a state such as completed, in error, or if it involves violation errors or warnings identified by the application monitor. For information about setting up email notifications, see Setting Up Email. For information about the application monitor, see Administering Planning for Oracle Planning and Budgeting Cloud Service.

  • You cannot cancel or start a job from the Job Console page.

  • Administrators can view all jobs and their status. All other users can view only their own jobs and their status.

To check the execution status of jobs:

  1. Perform a task:
    • Select Tools, and then Job Console.

    • Open Job Console type task.

    This job information is displayed:

    • Job ID: Generated by the database.

    • Job Type: Business Rule, Ruleset, Clear Cell Details, Copy Data, or Push Data.

    • Job Name: The business rule, sequence, or ruleset name.

    • User Name: The user who launched the job.

    • Start Time

    • End Time: Whether the job was completed or ended in an error.

    • Run Status: Current job state such.

      Note:

      Use the Completed with Threshold Violations status to identify jobs that ran successfully but came close to exceeding the recommended performance thresholds. See "Monitoring and Optimizing Application Integrity and Performance" in Administering Planning for Oracle Planning and Budgeting Cloud Service.

  2. To filter which jobs are displayed, specify any of the following:
    • Start Time—When jobs were run. Click select date icon to specify the day, month, year, and time.

    • End Time—The date by which jobs were completed. Click select date icon to specify the day, month, year, and time.

    • Job Type—The kind of job performed or the artifact involved, such as Ruleset, Push Data, or Copy Decision Packages.

    • Status—The current state of jobs such as Processing or Completed.

      Use the Completed with Threshold Violations status to filter for jobs that ran successfully, but do not comply to the recommended performance thresholds. See "Monitoring and Optimizing Application Performance" in the Oracle Hyperion Planning Administrator's Guide.

    • Job Name

    • User—The user who submitted the job

  3. Click go.

    The Job Console displays the jobs matching your selection criteria.

  4. 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 and rulesets: The application, plan type, and runtime values. If the rule generated an error, then a text box displays the error.

      Note:

      Information on rulesets is displayed as expandable hierarchies, and status is displayed individually for each embedded rule and ruleset as they are processed.

    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, adding the property CAPTURE_RTP_ON_JOB_CONSOLE, and then setting its value to FALSE. See Oracle Hyperion Planning Administrator's Guide.

  5. 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.

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