Stack Overflow
Stack Overflow

Questions tagged [dbms-scheduler]

An Oracle scheduling package.

dbms_scheduler is an Oracle scheduling package, which provides methods of scheduling single jobs or groups of jobs at regular intervals or based on a calendar.

Questions tagged should also be tagged .

Further reading:

213 questions
0
votes
1 answer

dba_scheduler_job_run_details and dbms_output

dba_scheduler_job_run_details is capable to keep an dbms_output.put_line lines in dba_scheduler_job_run_details.output column. And it is so, when the job flows and exits normally. However, when I explicitly call dbms_scheduler.stop_job - all the…
Andrew Klimov
  • 126
  • 8
0
votes
1 answer

DBMS Scheduler error: ORA-27367: program "Schema.PROG_programname" associated with this job is disabled

I have created an oracle job using dbms scheduler.But the status gets failed in the execution. It gives the following error. 'ORA-27367: program "Schema.PROG_SIXMONTHPRIORITY" associated with this job is disabled' But I do not have disabled the job.…
Rmd90
  • 97
  • 4
0
votes
1 answer

Strange oracle job behavior

I face a problem with an oracle job This job runs every 10 min and it calls a procedure from a package. Inside the procedure, there is a select and then a loop. The select could return from 10 to 1000 rows For one week everything was running fine (,…
Nianios
  • 1,391
  • 3
  • 20
  • 45
0
votes
1 answer

data base job scheduler time limit

i have many schedule jobs some are working after 15 minutes ,some are after 1 hour and some are after 5 seconds ,how can i manage them between 6:am to 7:pm. all executes at their own time but between 6:am to 7:pm. i am highly waiting of your kind…
Rana Imran Ahmed
  • 1
  • 2
0
votes
1 answer

call back in dbms_scheduler job Oracle

When we start a job via dbms_schedular, it creates a record in *_SCHEDULER_JOBS Is there a way at the middle or end of a job. I write onto the record Example: Job_A spawns Procedure_B And inside Procedure_B, I can write back to the record in…
Andrew C. Kee
  • 69
  • 1
  • 4
0
votes
2 answers

Zip compress without root folders

My problem is that I have to generate a zip file using the linux zip console command. My command is as follows: zip -r /folder1/folder2/EXP_45.zip /folder1/folder2/EXP_45/ That returns a correct zip only that includes the root folders I…
Drunkpunk Men
  • 56
  • 6
0
votes
1 answer

oracle dbms_scheduler privileges issue

In my DB I set up 2 schemas, schemaA and schemaB. In schemaA I create a job (jobA) and a procedure (procA) to set arguments and enable the job. I test the flow in schemaA and it's working correctly. In schemaB I need to call schemaA.procA in order…
AlexMI
  • 824
  • 1
  • 15
  • 36
0
votes
1 answer

oracle scheduler job not running (after enabling it)

I created a scheduler job in the following way: BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'update_sales_1', job_type => 'STORED_PROCEDURE', job_action => 'test_job', start_date => …
Prosenjit
  • 3
  • 4
0
votes
1 answer

Oracle 12c: Running scheduled job with date interval

I have the following script: SELECT USERNAME ITEM BUSINESS ADDED FROM BUSINESS WHERE BUSINESS IN ('X','Y','Z') AND ADDED BETWEEN TO_DATE('8/30/2019 00:00:00', 'MM/DD/YYYY HH24:MI:SS') AND TO_DATE('9/30/2019 11:59:59', 'MM/DD/YYYY HH24:MI:SS') The…
hootsauce
  • 39
  • 5
0
votes
1 answer

How to pull data from an external source (REST API) with Oracle SQL?

I'm evaluating the possibility of pulling XML data from an external service (REST API) over the internet by using Oracle SQL DBMS_Scheduler. This would ideally be an automated solution running on the database server. Is this technically possible and…
pa_tsti
  • 1
0
votes
1 answer

Is there a way to execute robocopy cmd from a Stored Procedure in PL/SQL?

I have to move certain files from a local directory(which is fixed) into another server. I can use robocopy from Windows cmd line to do the same. Is there a way in which i can create a job which executes this specific windows cmd for me in ORacle…
Deepak Hanumanthaiah
  • 21
  • 2
0
votes
1 answer

oracle dbms_scheduler.create_job() error when executed within stored procedure

Creating job from anonymous block is working fine: begin SYS.DBMS_SCHEDULER.create_job( job_name => 'test_job', job_type => 'PLSQL_BLOCK', job_action => 'begin null; end;', enabled => TRUE, auto_drop => …
waldemort
  • 31
  • 6
0
votes
1 answer

how to make dbms_scheduler.create_job configurable?

Rather than hard-coding values dbms_scheduler.create_job repaeat_interval, i'd like to make it configurable. Therefore, I have created a new table that allows the repeat_interval from the job to be configured. Procedure below takes the column as…
j_deany
  • 67
  • 10
0
votes
1 answer

how to define a dbms_scheduler.create_job in a pl/sql package?

BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'delete_partition', job_type => 'STORED_PROCEDURE', start_date => '28-APR-08 07.00.00 PM Australia/Sydney', repeat_interval => 'FREQ=MONTHLY;INTERVAL=1', /*…
p_eazy
  • 27
  • 1
  • 6
0
votes
0 answers

DBMS_SCHEDULER job calls SP but doesn't update the date on each execution

I'm creating a DBMS_SCHEDULER job that runs a stored procedure. This procedure builds a report based on the input parameters, and the result is left in a file, like this: Job: DBMS_SCHEDULER.CREATE_JOB(job_name => 'REPORT', …
Hugo M. Zuleta
  • 572
  • 1
  • 13
  • 27
1 2 3
…
14 15