|
Oracle Job Scheduling: Creating Robust Task Management with dbms_Job & Oracle 10g dbms_Scheduler
Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All
code scripts are available for instant download from a companion web site.
Chapter 1 - External Oracle job scheduling
Introduction
External Oracle job scheduling
Using cron and crontab in UNIX and Linux
Using the Windows job schedulers
AT.EXE
Scheduled Tasks Wizard
SCHTASKS.EXE
Internal Oracle job Scheduling
Oracle 9i Scheduler Overview
Oracle 10g Scheduler Overview
Features comparison between dbms_job and dbms_scheduler
Migrating from dbms_job to dbms_scheduler
Summary
Chapter 2 - Configuring Oracle Job Scheduling
Introduction
Setting up a test environment
Overview and examples of dbms_job functions
Data dictionary views related to dbms_job
dba_jobs
dba_jobs_running
Overview and examples of dbms_scheduler functions
Scheduler Privileges
Programs
Schedules
Jobs
Job Classes
Windows
Window Groups
Enabling, disabling and setting attributes of scheduler objects
Data dictionary views related to dbms_scheduler
Summary
Chapter 3 - Time-Based Job Scheduling
Introduction
Dates
Timestamps
Intervals and Interval Literals
Calendar Syntax in Oracle 10g
Complex Date Rules for Job Execution
Summary
Chapter 4 - Chaining Oracle Jobs Together
Introduction
Creating a job chain
Conditional job creation
Conditional job enabling
Conditional job runs using Oracle Advanced Queuing
Conditional job runs using a custom table solution
Implementing error checking routines
Implementing conditional job execution
Sending email notifications of job errors
Using UTL_SMTP
Using UTL_MAIL in Oracle 10g
Running OS commands and scripts from PL/SQL
Summary
Chapter 5 - Monitoring Oracle Job Execution
Introduction
Monitoring Jobs (pre 10g)
Monitoring Jobs in 10g
Monitoring Sessions
Killing Oracle Sessions
DBMS_APPLICATION_INFO
DBMS_SYSTEM
Summary
Chapter 6 - Advanced Scheduling Topics
Introduction
Setting Scheduler Attributes
current_open_window
default_timezone
log_history
max_job_slave_processes
Job Priorities
Scheduler Logging
Job Logs
Job Run Details
Window Logs
Purging Logs
Resource Manager
Export/Import and the Scheduler
Services and Instance Stickiness
Security
Setting Scheduler Object Attributes
Summary
|
