Question: I have stopped a running chain with
the dbms_scheduler.stop_job procedure.
begin
sys.dbms_scheduler.stop_job (
job_name =>'zztop1',
force => true
);
end;
/
The problem is when I try to restart the job chain with
dbms_scheduler.alter_running_chain, I get the error that there is no
running job with this name.
sys.dbms_scheduler.alter_running_chain('zzyop01',
's50', 'state', 'not_started');
How do I stop a job chain and re-start the chain at the stopped
job step?
Answer: I would look at pausing the job
step instead of stopping it . . .
sys.dbms_scheduler.alter_running_chain('zzyop01',
's50',
'state',
'paused’);
Oracle has a great tool for suspending job chains via
dbms_scheduler.alter_running_chain “pause=true”, which allows all
steps in a job chain to stop and be re-started, at the point
immediately after the last job step completes.
You can use dbms_scheduler.alter_running_chain “pause=true” to
suspend execution in many places in a job chain, and re-start the
job chain at-will.
If the dbms_scheduler.alter_running_chain “pause=true” is set,
the job will stop right after it has completed execution and
“completed=false” remains set.
Conversely, if the dbms_scheduler.alter_running_chain
“pause=false” is set, the job will stop right after it has
completed execution and “completed=true” remains set.
This is why your call to set state = ‘not started” with
dbms_scheduler.alter_running_chain failed . . .
Because the job was already stopped.
When starting Oracle after an instance failure, Oracle will make
a consistent database by applying undo logs for a in-flight
transactions chain job steps.
Remember that a job stops that were running at the time of the
failure are marked as stopped and the chain continues processing at
the point of the last completed chain step.
You can have Oracle job chain steps restart automatically after a
database recovery by using alter_chain directive to set the
restart_on_recovery attribute to true for those steps.
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
