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:
Section 26.2, "Adding Oracle BI Scheduler Jobs in Job Manager"
Section 26.3, "Modifying Oracle BI Scheduler Jobs in the 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:
Open the Oracle BI Administration Tool.
From the toolbar, click the Manage menu, and select Jobs.
Job Manager opens in a new window.
In Job Manager, from the toolbar, click the File menu, and select Open Scheduler Connection.
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 Section 6.2.1, "Using Fusion Middleware Control to Configure Primary and Secondary Instances.".
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:
In the Job Manager, from the Jobs menu, select Add New Job.
Enter the appropriate information in the dialog box.
See the following sections for field descriptions:
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:
In the Job Manager, select the job to modify.
From the Jobs menu, select Modify Job.
In the Modify Job dialog box, change the job properties.
For field descriptions, see Section 29.3, "General Oracle BI Scheduler Job Properties," Section 29.4, "Job Action Properties Available in Job Manager," and Section 29.5, "Job Triggers in Job Manager."
You cannot add agent jobs using the Job Manager. Agents are most commonly added through Oracle BI Presentation Services. For information, see Section 24.1, "What is Oracle BI Scheduler?"
You can, however, modify an agent job using the Modify Job dialog box. For information, see Section 26.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:
In Job Manager, select the agent to modify.
From the Jobs menu, select Modify Job.
In the Modify Job dialog box, change the agent job properties.
For field descriptions, see Section 29.3, "General Oracle BI Scheduler Job Properties," Section 29.4, "Job Action Properties Available in Job Manager," and Section 29.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 Section 20.3.3.3, "Agent Scheduler Configuration Settings" 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. |
You can re-run any type of job, including an agent job that failed. 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:
Open the Oracle BI Administration Tool in Online mode.
From the Manage menu, select Jobs from the toolbar.
The Job Manager window is displayed.
Go to the Instance list.
Locate the job instance to re-run.
Right-click the job instance and select Re-run Instance(s) Now.
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:
Section 26.7.1, "Viewing or Refreshing Oracle BI Scheduler Job Instances"
Section 26.7.2, "Cancelling Oracle BI Scheduler Job Instances"
To work with Oracle BI Scheduler job instances:
Click the Instances tab in the lower-left corner of the Job Manager window.
When instances are present, use the tree in the left pane to locate instances and view information about them.
The Instances menu is described in the table in Section 29.2.4, "Instances Menu in Job Manager."
Instances properties are described in the table in Section 29.2.5, "Instance Properties in Job Manager."
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:
Open the Oracle BI Administration Tool in Online mode.
From the Manage menu, select Jobs from the toolbar.
The Job Manager window is displayed.
Go to the Instance list.
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 29.2.4, "Instances Menu in Job Manager."
To refresh Oracle BI Scheduler job instances:
In the Instance List, from the Instances menu, select Refresh Instance List.
Registered canceled instances are described in Section 27.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:
Open the Oracle BI Administration Tool in Online mode.
From the Manage menu, select Jobs from the toolbar.
The Job Manager window is displayed.
Go to the Instance list.
Select a particular job instance, and from the Instances menu, select Cancel Instance(s).
Purging a job instance involves removing it from the back-end database using one of the following methods:
The following procedure purges Oracle BI Scheduler job instances through the Instances List.
To purge Oracle BI Scheduler job instances through the Instances List:
Open the Oracle BI Administration Tool in online mode.
From the Manage menu, select Jobs from the toolbar.
The Job Manager window is displayed.
Go to the Instance list.
Select the instances from the Instance List and click Delete.
The following procedure purges job instances through the Purge Instances window.
To purge Oracle BI Scheduler job instances through the Purge Instances window:
Open the Oracle BI Administration Tool in online mode.
From the Manage menu, select Jobs from the toolbar.
The Job Manager window is displayed.
Go to the Instance list.
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.
Select the purge method to use.
Click OK when you have finished to return to the Job Manager window.