Trying to make a job to be executed after each 1 minute,but its not working?

Posted by Vineet on Stack Overflow See other posts from Stack Overflow or by Vineet
Published on 2010-05-02T08:39:22Z Indexed on 2010/05/02 8:47 UTC
Read the original article Hit count: 130

Filed under:

plsql

|

plsqldeveloper

|

oracle9i

I have made this job,that should be executed in an interval of 1 minute,but its not working .When i use execute dbms_job.run(2); it gets executed.printe is a procedure Please suggest!

BEGIN
   DBMS_JOB.SUBMIT
    (
    job =>:job_no,
    WHAT=>'printe;',--Procedure 
    next_date=>sysdate+1/24*60,
  interval=>'sysdate+1/24*60'
  );
  commit;
  END;

© Stack Overflow or respective owner

Related posts about plsql

Iterating over files in PLSQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Using a PLSQL script, is it possible to iterate over binary files in a folder and insert them as a BLOB in Oracle 10g? Any examples would be appreciated. >>> More
plsql show query

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I have a small problem using oracle pl sql. I have a sql file with some cursor, etc, and the treatement fail but with no details. I have an idea about the problem (a function with parameters) but I would like to see the parameter for each call, to be able to debug, to see exactly with wich… >>> More
Get 2 recoeds from PLSQL Cursor

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys... my Question is short, I create a cursor to get some values from my table I want to get the current record of cursor (the fetched record) and the next record from the cursor without fetching it, cause I want to make a calculation over the current record and the next record. in traditional… >>> More
Get two records from PLSQL cursor

as seen on Stack Overflow - Search for 'Stack Overflow'
My question is short. I create a cursor to get some values from my table. I want to get the current record of cursor (the fetched record) and the next record from the cursor without fetching it, because I want to make a calculation over the current record and the next record. In traditional programming… >>> More
PLSQL: How to go about it

as seen on Stack Overflow - Search for 'Stack Overflow'
I searched for this topic on SO but I did not found any recommendations and so am asking it as I am new to PLSQL and want to understand it: What is best way to get started with PLSQL ? What are best online resources or books available out there for understand PLSQL which you would recommend ? Do… >>> More

Related posts about plsqldeveloper

to_date function pl/sql

as seen on Stack Overflow - Search for 'Stack Overflow'
undefine dates declare v_dateInput VARCHAR(10); v_dates DATE; begin v_dateInput := &&dates; v_dates := to_date(v_dateInput,'dd-mm-yyyy'); DBMS_OUTPUT.put_line(v_dates); end; Not sure why whenever I run this code with ,for example , input of 03-03-1990, this error shows up. Error… >>> More
Any one knows boolean size in Pl/Sql?

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to know boolean data type size in pl/sql ,since in other languages it is 1 bit, I don't know about pl/sql. Please let me know!! >>> More
oracle pl/sql bug: can't put_line more than 2000 characters

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anyone else noticed this phenomenon where dbms_output.put_line is unable to print more than 2000 characters at a time? Script is: set serveroutput on size 100000; declare big_str varchar2(2009); begin for i in 1..2009 loop big_str := big_str||'x'; end loop; dbms_output… >>> More
UTL_FILE.FOPEN() procedure not accepting path for directory ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to write in a file stored in c:\ drive named vin1.txt and getting this error .Please suggest! > ERROR at line 1: ORA-29280: invalid > directory path ORA-06512: at > "SYS.UTL_FILE", line 18 ORA-06512: at > "SYS.UTL_FILE", line 424 ORA-06512: at > "SCOTT.SAL_STATUS", line… >>> More
No_data_found exception is progating in outer block also?

as seen on Stack Overflow - Search for 'Stack Overflow'
In my code i am entering the salary which is not available in employees table and then again inserting duplicate employee_id in primary key column of employee table in exception block where i am handling no data found exception but i do not why 'No data found exception in the end also? OUTPUT coming: Enter… >>> More