Tagged Questions
1
vote
1answer
76 views
Passing parameters to a procedure executed by DBMS_SCHEDULER
I have a scheduler program that runs a stored procedure that requires input parameters.
BEGIN
DBMS_SCHEDULER.DROP_PROGRAM
(program_name => 'MYSCHEMA.EXPORT_SCHEMA_STARTING');
END;
...
1
vote
1answer
106 views
Force chain to start immediately after completion instead of on a timer
Is it possible to force an Oracle chain to restart immediately after it finishes executing, instead of on a timer? I have only found ways to do a temporal restart, which doesn't really work for me as ...
0
votes
1answer
28 views
Oracle scheduler max_jobs_Slave_processes is set to null, how many will be allocated?
Executing the following query against my database:
select value
from dba_scheduler_global_attribute
where attribute_name='MAX_JOB_SLAVE_PROCESSES';
yields a value of NULL. My question is what ...
0
votes
1answer
30 views
Oracle scheduler chain priority in data warehouse applications
The scenario is as follows:
We have a data warehouse type application that relies on the Oracle job scheduler and a Chain. This chain is responsible for generating materialized views (caches) that ...
1
vote
0answers
68 views
Pass in dynamic value to Oracle job scheduler
How does one pass a dynamic value into the oracle job scheduler when the underlying command is a stored procedure?
example procedure:
create procedure foo (bar varchar2)
...
Job creation in ...
0
votes
0answers
63 views
can I update a view using Oracle scheduler?
I have a view and some UIs displaying this view. The UIs should check for updates of that view periodically. I want Oracle database to trigger this event. Can I use Oracle scheduler for this? And How?
...
