Top "Dbms-scheduler" questions

An Oracle scheduling package.

DBMS_SCHEDULER.DROP_JOB only if exists

I have a sql script that I must run after I import a dump. among other things the script does, …

oracle oracle11g dbms-scheduler
dbms_scheduler.run_job('jobName) fails to run

I'm trying to run a scheduled job manually, the job looksa like this DBMS_SCHEDULER.CREATE_JOB ( job_name => …

oracle stored-procedures plsql dbms-scheduler
How to execute a procedure with DBMS_SCHEDULER.CREATE_JOB procedure

I want to create a job that would drop a database object at a given date. The job created all …

oracle oracle10g dbms-scheduler
Passing arguments to oracle stored procedure through scheduler job

I have a stored procedure which is being called from a dbms job. i.e. DBMS_SCHEDULER.RUN_JOB ('Procedure_…

stored-procedures plsql oracle10g scheduler dbms-scheduler
How to schedule an Oracle dbms_scheduler Job timezone and DST safely

I am trying to setup a DBMS_SCHEDULER Job to run exactly at 1 AM on 1st of January every year …

oracle11g timezone dst job-scheduling dbms-scheduler
DBMS_JOB vs DBMS_SCHEDULER

What is the difference between DBMS_JOB and DBMS_SCHEDULER ?

oracle scheduler job-scheduling dbms-scheduler dbms-job
Cannot stop/drop job in DBMS_SCHEDULER

I managed to run a job from DBMS_SCHEDULER. But is running since yesterday and I cannot stop it. The …

oracle oracle11g dbms-scheduler
An Oracle database user cannot create a DB job even with relevant privileges

I have an Oracle database user named "ADMUSER" with following privileges, which are the required privileges for creating a database …

oracle stored-procedures oracle10g dbms-scheduler
Set named parameter for Oracle dbms_scheduler job stored procedure

Is it possible to passed named arguments to for dbms_scheduler job with a type 'stored_procedure' ? I've tried this …

stored-procedures plsql oracle10g named-parameters dbms-scheduler
Altering JOB_QUEUE_PROCESSES

Does altering the JOB_QUEUE_PROCESSES to 0 on an Oracle DB block the Oracle jobs from being scheduled too? I …

database oracle dbms-scheduler dbms-job