This is your practical guide to setting up a working environment and using Oracle Scheduler. Packed with simple examples and clear explanations, real-life scenarios are discussed to make you comfortable in implementing them in your own system. This book is intended for Administrators and Developers who currently use tools like cron, DBMS_JOB, and the task manager, but who now want more control or who have a need to scale up to tools that can handle the network. Complex tasks can be built that easily control business process and enable the completion of important tasks in limited time. The reader is expected to have some experience of Oracle Database Management, and a working knowledge of SQL and PL/SQL.
Author(s): Ronald Rood
Edition: 1st
Year: 2009
Language: English
Pages: 240
Cover......Page 0
Table of Contents......Page 8
Preface......Page 12
Simple Jobs......Page 18
Running your Jobs......Page 19
PL/SQL block......Page 20
Stored procedure......Page 26
Executable......Page 30
Program......Page 31
Metadata arguments......Page 33
Normal application arguments......Page 36
Summary......Page 38
Simple Chain......Page 40
Statuses......Page 41
Rules......Page 42
Evaluation interval......Page 43
Privileges......Page 45
Hands-on with chains......Page 46
COPYFILES......Page 47
Program state......Page 48
DB Console......Page 49
Chain definition......Page 52
Running the chain......Page 59
Tricks with chains......Page 60
Manipulating the running chains......Page 62
Analyzing the chain......Page 63
Summary......Page 66
Job creation......Page 68
Job execution......Page 74
Scheduler management......Page 77
Log detail level......Page 79
Log purging......Page 81
Summary......Page 84
Resource consumer group......Page 86
Creating resource consumer groups......Page 88
Class......Page 91
Plan......Page 93
Window......Page 102
Monitoring......Page 103
Problems with Resource Manager......Page 108
Problems that Resource Manager solves......Page 110
Summary......Page 112
Security......Page 114
Installation on Windows......Page 116
Installation on Linux......Page 121
Upgrading the remote job agent......Page 122
Patch to the latest available level......Page 123
Preparing the database for remote agent usage......Page 124
Setting the HTTP port......Page 125
Setting registration password......Page 126
Configuring a remote agent......Page 127
Troubleshooting......Page 128
Multiple agents on the same host......Page 129
Credentials......Page 131
Creating job—targeting Unix......Page 132
Creating job—targeting Windows......Page 136
Runtime observations of the remote Scheduler......Page 137
Summary......Page 138
Monitoring job events......Page 140
Events in chains......Page 141
Event-based scheduling......Page 144
Summary......Page 151
Unix—all releases......Page 152
Windows usage......Page 155
Bugs......Page 156
Job environment......Page 159
Checks to do in the database......Page 160
Summary......Page 163
Statistics collection......Page 164
The run procedure......Page 165
Generating the jobs......Page 166
Generating the scheduled run......Page 169
Things that can scare you......Page 171
Reading the event queue......Page 175
Scheduling for the HOT backups......Page 178
Scheduling the DARC process......Page 180
Scheduling the final BARC process......Page 182
How to use the calendar......Page 183
Tools......Page 184
Summary......Page 191
RAC......Page 192
Job creation/modification......Page 195
The job_class definition......Page 201
Creating jobs in a logical standby database......Page 202
Running jobs in a logical standby database......Page 204
Summary......Page 205
DB Console......Page 206
DbVisualizer......Page 227
Summary......Page 232
Index......Page 234
