Stack Overflow
Stack Overflow

Questions tagged [dbms-job]

A package in Oracle. The DBMS_JOB package schedules and manages jobs in the job queue.

The DBMS_JOB package has been superseded by the DBMS_SCHEDULER package (tag: ) package. Please also include the tag, and an appropriate Oracle version tag such as

60 questions
1
vote
1 answer

Oracle DBMS_SCHEDULER looping found error ORA-274278

I've some script for running bat file windows using DBMS_SCHEDULER. But there is some error when there is looping with several data. CREATE OR REPLACE procedure SEAT.ss_print_fundoshi_run_weld_tst (ptype varchar2) is cursor c_data is select * from…
reefman
  • 143
  • 4
  • 13
1
vote
1 answer

Can't understand Oracle job scheduling

I'm currently working on an assignment where I have to port some Oracle scripts to MS SQL. I ran into a problem at the scheduled jobs. The Oracle script looks like this: dbms_job.submit(job =>v_job, what =>'begin pkg_report.REFRESH_MVIEWS;…
Gábor Major
  • 444
  • 2
  • 8
  • 23
1
vote
1 answer

Schedule a job on specific dates using DBMS_JOB

I have job, created using DBMS_JOB, which runs daily at 1:00 am WHAT PROC_XYZ(); NEXT_DATE 16-OCT-13 NEXT_SEC 01:00:00 INTERVAL trunc(sysdate)+1+1/24 I want to change it to run at specific dates (with no pattern or…
Stu
  • 249
  • 2
  • 6
  • 17
1
vote
2 answers

Call a Procedure with parametes through DBMS_JOB.SUBMIT

I am working on Oracle 11gR1 I have to call a procedure which accepts a CLOB as input parameter through a DBMS_JOB.SUBMIT procedure. Here is my code for the same: FOR i IN 1 .. lrec_resultset.COUNT LOOP DBMS_JOB.SUBMIT ( …
Incognito
  • 2,964
  • 2
  • 27
  • 40
0
votes
1 answer

Is there a built-in function to parse oracle dbms_job interval string and get next_date?

I am trying to implement the same interval string format oracle uses for dbms_job for some custom processing logic. I wrote a function using execute immediate, I wonder if there is a built-in function that I could call directly. function…
akaya
  • 110
  • 4
  • 9
0
votes
1 answer

Oracle job alert for DBMS job

I am trying to create an alert for a dbms scheduler job if it is running for a duration longer than expected. For example, if a job that usually takes 2 hours to run is now running for more than 2.5 hours, I want to be notified. What would be the…
Kuwali
  • 233
  • 3
  • 13
0
votes
1 answer

create scheduler jobs owned by user1 when logging in as sys in oracle sql

I want to create a scheduled job in oracle sql whose owner is user1 when logging in sys. the job is supposed to run a stored procedure which takes an argument. I was able to create the job myjob which belongs to the sys user, but not user1. I tried…
jiii
  • 71
  • 4
0
votes
1 answer

Passing a variable to DBMS Parallel Execute SQL Statement

/*FOO Process Variables*/ l_chunk_sql VARCHAR2(1000); l_sql_stmt varchar2(1000); v_date DATE := trunc(sysdate) + 5; v_order_time VARCHAR2(200) := 'AFTERNOON'; v_flag VARCHAR2(1) :=…
Developer
  • 3
  • 3
0
votes
1 answer

DBMS_JOB.SUBMIT interval interpretation

I want to understand a dbms_job.submit statement dbms_job.submit(jobno, 'xxxsome_pl_sql_statement',next_date,interval); next_date evaluates to Last_Day(Sysdate) ----30-apr-22 interval evaluates to Last_Day(Add_Months(Sysdate,1))…
jiii
  • 71
  • 4
0
votes
2 answers

How to run block of code in Postgres asynchronously (like a job)?

Can we execute a block of code outside of current session? In other words, delegate the execution to another working thread, something like a dbms_job.submit in Oracle. I found only solutions involving external tools like Cron, but do not see any…
diziaq
  • 6,881
  • 16
  • 54
  • 96
0
votes
0 answers

I need to join the two tables in the following way.. using mysql

Table 1 Country Export China 90 India 80 Korea 40 Table 2 Country Import China 40 India 30 Japan 50 Result Country Export Import China 90 40 India 80 30 Korea 40 0 Japan 0 50
Arjunkumar
  • 1
  • 1
0
votes
2 answers

Oracle Scheduler Jobs with multiple frequency

I am creating Scheduler Jobs for doing Backup via stored procedure and I am in kind of a situation that, the user will be selecting multiple frequencies like In first case user selects Monthly as frequency of Job. In second case user selects Weekly…
mohammed mazin
  • 445
  • 3
  • 15
0
votes
1 answer

Replace ' by ''

I want to use DBMS_JOB.SUBMIT inside a function from package, I use it like this : if i_iscsv then dbms('true'); DBMS_JOB.SUBMIT(jobno, 'DECLARE BEGIN get('||req||',…
DEVLOGIN
  • 87
  • 1
  • 9
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

JSON String to CLOB object

I am creating new dbms_job, using java code, job is creating successfully but processing it is failing to call job_action. in job_action I am calling procedure to invoke oracle loaded java code. the clob is consist of json string. Seems json format…
2787184
  • 3,749
  • 10
  • 47
  • 81
1 2
3
4