Click here to Skip to main content
15,885,366 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a Stored procedure which needs to be run every minute, for that I have a job in Oracle 10g. I have created a job

SQL
BEGIN
  -- Job defined entirely by the CREATE JOB procedure.
  DBMS_SCHEDULER.create_job (
    job_name        => 'Update_Status',
    job_type        => 'PLSQL_BLOCK',
    job_action      => 'BEGIN ;updateStatus; END;',
    start_date      => SYSTIMESTAMP,
    repeat_interval => 'freq=minutely; bysecond=0;',
    end_date        => NULL,
    enabled         => TRUE,
  auto_drop          =>   FALSE,
    comments        => 'Job defined entirely by the CREATE JOB procedure.');
END;

This above job needs to run for every one minute. But the status is not being updated? I do not know whether the job is stared or not how to get the status of the job, How to make it run?
Posted
Updated 10-Jul-13 23:41pm
v2
Comments
ZurdoDev 10-Jul-13 7:49am    
I don't know Oracle but SQL has a scheduler feature built in. I would imagine Oracle does too.

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900