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 particular 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: The sequential number that the database generates for each started job.

    • Job Type: Business Rule, Ruleset, 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 Expand icon . Planning 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 that the job ended.

    • Run Status: Current job state such as Processing or Completed.

      Note:

      Use the Completed with Threshold Violations status to identify jobs that ran successfully, but that 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 PlanningAdministrator's Guide.

    • Job Name—Job name

    • User—The ID of 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, a text box displays the error.

      Note:

      Information on rulesets display 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.