Skip Headers
Oracle® Fusion Middleware Scheduling Jobs Guide for Oracle Business Intelligence Enterprise Edition
11g Release 1 (11.1.1)

Part Number E18562-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3 Using Oracle BI Scheduler Job Manager

This chapter describes how to manage Oracle BI Scheduler using the Job Manager feature in the Oracle BI Administration Tool. This chapter contains the following topics:

3.1 Opening Job Manager

The Job Manager is a Windows tool that is the interface with the Oracle BI Scheduler. Through Job Manager, you can connect to, start and stop the Oracle BI Scheduler, add and manage jobs, and manage job instances. You create and edit agents using Oracle BI Presentation Services. For information, see Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition.

The following procedure describes how to open Job Manager from the Oracle BI Administration Tool.

To open the Job Manager:

  1. Open the Oracle BI Administration Tool.

  2. From the toolbar, click the Manage menu, and select Jobs.

    Job Manager opens in a new window.

  3. In Job Manager, from the toolbar, click the File menu, and select Open Scheduler Connection.

  4. In the Machine Name dialog box, enter the machine name and port number where the Oracle BI Scheduler is located, and click OK.

    You can learn the machine name (host) and port number by displaying the Availability tab of the Capacity Management page in Fusion Middleware Control. For information, see "Using Fusion Middleware Control to Configure Primary and Secondary Instances" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

3.2 Adding Oracle BI Scheduler Jobs in Job Manager

Job Manager enables you to add new scripted jobs. Agents can only be created in Oracle BI Presentation Services.

Add an Oracle BI Scheduler job in the Job Manager using the following procedure.

To add an Oracle BI Scheduler job in the Job Manager:

  1. In the Job Manager, from the Jobs menu, select Add New Job.

  2. Enter the appropriate information in the dialog box.

    See the following sections for field descriptions:

3.3 Modifying Oracle BI Scheduler Jobs in the Job Manager

You can modify an Oracle BI Scheduler job in the Job Manager using the following procedure.

Note:

If, while adding or modifying a job in the Job Manager, you enter a script in the Script field, then the Oracle BI Scheduler creates a file with an SCS extension in the following directory:

\orainst\bifoundation\<OracleBISchedulerComponent>\coreapplication_obisch1\scripts\scheduler

Where orainst is the install location for Oracle Business Intelligence.

Oracle BI Scheduler's job scripts are stored in this location (not in the back-end database), so do not remove scripts from here.

To modify an Oracle BI Scheduler job in the Job Manager:

  1. In the Job Manager, select the job to modify.

  2. From the Jobs menu, select Modify Job.

  3. In the Modify Job dialog box, change the job properties.

    For field descriptions, see Section 6.3, "General Oracle BI Scheduler Job Properties," Section 6.4, "Job Action Properties Available in Job Manager," and Section 6.5, "Job Triggers in Job Manager."

3.4 About Adding Agent Jobs

You cannot add agent jobs using the Job Manager. Agents are most commonly added through Oracle BI Presentation Services. For information, see Section 1.1, "What is Oracle BI Scheduler?"

You can, however, modify an agent job using the Modify Job dialog box. For information, see Section 3.5, "Modifying Agents in Job Manager."

3.5 Modifying Agents in Job Manager

You can modify an individual agent using the Modify Job dialog box in the Job Manager.

To modify an agent in Job Manager:

  1. In Job Manager, select the agent to modify.

  2. From the Jobs menu, select Modify Job.

  3. In the Modify Job dialog box, change the agent job properties.

    For field descriptions, see Section 6.3, "General Oracle BI Scheduler Job Properties," Section 6.4, "Job Action Properties Available in Job Manager," and Section 6.5, "Job Triggers in Job Manager."

Agent-specific job properties are described in the following table.

Note:

A default value in these fields indicates that the value that is specified in "Agent Scheduler Configuration Settings"Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition is active.
Agent Property Description
BI Presentation Server Specifies the Web server that this agent contacts when it runs.

Do not change this setting, because the agent might not exist on a different Web server. This feature was added for debugging purposes only.

Debug Log Determines whether debugging information is written to a log. This overrides the Scheduler's Debug configuration setting for just this one agent. If set to true, then log files named Agent-<jobID>-<InstanceID>.log are created in the active Scheduler's log directory when the agent is executed.

3.6 Re-Running a Job Instance

You can re-run any type of job with failed job instances to deliver results to recipients which haven't received the agent (for example, agent jobs with status Failed, Warning, Cancelled, Timed Out)). When you re-run a failed agent job, only the failed items are delivered. For example, if there are 1,000 recipients of an agent, but 200 of those recipients belonged to a group that does not have the appropriate request viewing permissions, then the administrator can correct the permission settings and re-run the job. In this example, only the 200 users in the modified group receive the agent. The agent is not re-delivered to the other 800 users who successfully received the agent.

To re-run a job instance:

  1. Open the Oracle BI Administration Tool in Online mode.

  2. From the Manage menu, select Jobs from the toolbar.

    The Job Manager window is displayed.

  3. Go to the Instance list.

  4. Locate the job instance to re-run.

  5. Right-click the job instance and select Re-run Instance(s) Now.

    The Re-run Instance(s) Now menu option is not available for successfully completed jobs.

3.7 Managing Oracle BI Scheduler Job Instances

An instance in the Oracle BI Scheduler is a record that stores information regarding a specific execution of an Oracle BI Scheduler job.

You can perform the following tasks using Oracle BI Scheduler job instances:

To work with Oracle BI Scheduler job instances:

  1. Click the Instances tab in the lower-left corner of the Job Manager window.

  2. When instances are present, use the tree in the left pane to locate instances and view information about them.

3.7.1 Viewing or Refreshing Oracle BI Scheduler Job Instances

You can view Oracle BI Scheduler job instance information using the following procedure.

Note:

In some environments, if numerous instances have run and instances have not been purged in some time, then this process can take a few seconds.

To view Oracle BI Scheduler job instance information:

  1. Open the Oracle BI Administration Tool in Online mode.

  2. From the Manage menu, select Jobs from the toolbar.

    The Job Manager window is displayed.

  3. Go to the Instance list.

  4. Select a particular job instance and from the Instances menu, select View Instance.

    A description of the Instance properties shown in the Instance window is given in Section 6.2.4, "Instances Menu in Job Manager."

To refresh Oracle BI Scheduler job instances:

  1. In the Instance List, from the Instances menu, select Refresh Instance List.

3.7.2 Cancelling Oracle BI Scheduler Job Instances

Registered canceled instances are described in Section 4.8.6, "RegisterCancelCommand Method." The cancel event is issued to the Oracle BI Scheduler and the instance is marked as canceled when its registered cancel methods are called.

To cancel an Oracle BI Scheduler job instance:

  1. Open the Oracle BI Administration Tool in Online mode.

  2. From the Manage menu, select Jobs from the toolbar.

    The Job Manager window is displayed.

  3. Go to the Instance list.

  4. Select a particular job instance, and from the Instances menu, select Cancel Instance(s).

3.7.3 Purging Oracle BI Scheduler Job Instances

Purging a job instance involves removing it from the back-end database using one of the following methods:

3.7.3.1 Using the Job Manager Instances List

The following procedure purges Oracle BI Scheduler job instances through the Instances List.

To purge Oracle BI Scheduler job instances through the Instances List:

  1. Open the Oracle BI Administration Tool in online mode.

  2. From the Manage menu, select Jobs from the toolbar.

    The Job Manager window is displayed.

  3. Go to the Instance list.

  4. Select the instances from the Instance List and click Delete.

3.7.3.2 Using the Job Manager Purge Instances Window

The following procedure purges job instances through the Purge Instances window.

To purge Oracle BI Scheduler job instances through the Purge Instances window:

  1. Open the Oracle BI Administration Tool in online mode.

  2. From the Manage menu, select Jobs from the toolbar.

    The Job Manager window is displayed.

  3. Go to the Instance list.

  4. Click the Purge Instance(s) icon on the toolbar or from the Instances menu, select Purge Instances to open the Purge Instances window.

    You can purge instances by JobID, by UserID, or by End Time.

    If you select the End Time method, then all jobs with an End Time less than or equal to the given time are purged.

  5. Select the purge method to use.

  6. Click OK when you have finished to return to the Job Manager window.