Use this Knowledge Script to monitor the scheduled job status in the New Oracle Scheduler. When the scheduled job fails, the job raises an event.
The account you use to run this script must have SELECT permissions for the following tables:
Oracle Database folders. When you drop a script on an Oracle Database folder, a job executes on that database and monitors only that database.
The default interval for this script is Every 10 minutes.
Set the following parameters as needed:
|
Description |
How to Set It |
|---|---|
|
Oracle Username |
Enter the username that this script needs to access the target databases. If you run this script on more than one database, configure each database with the same username. To use SYSDBA authentication, leave this parameter blank. The default is blank. |
|
Collect data for Oracle Scheduled Jobs? |
Select Yes to collect data for Oracle scheduled jobs. When there are no failed jobs, the default is 0. The default is unselected. |
|
Include Jobs Scheduled with New Oracle Scheduler? |
Select Yes to include jobs scheduled with the New Oracle Scheduler. NOTE:You can use the New Oracle Scheduler with Oracle RDBMS 10g Release 1 and later. The default is unselected. |
|
Raise event if Jobs Failed? |
Select Yes to raise an event when the scheduled jobs fail. The default is selected. |
|
Severity |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator). |
|
Event severity for internal failure |
Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red event indicator). |