<div>
Have you checked to make sure your stored procedure runs properly by itself and updates the status?<br />
<br />
If so, have you run the job manually and verified that the status is being updated?<br />
<br />
If so, have you run the job manually every minute (for a few minutes) and verified that the status is being updated?
</div>


<div>
<div class="content wysiwyg-content">
I have a Stored procedure which needs to be run every minute, for that I have a job in Oracle 10g. &nbsp;I have created a job<br />
<br />
BEGIN<br />
&nbsp; -- Job defined entirely by the CREATE JOB procedure.<br />
&nbsp; DBMS_SCHEDULER.create_job (<br />
&nbsp; &nbsp; job_name &nbsp; &nbsp; &nbsp; &nbsp;=&gt; 'Update_Status',<br />
&nbsp; &nbsp; job_type &nbsp; &nbsp; &nbsp; &nbsp;=&gt; 'PLSQL_BLOCK',<br />
&nbsp; &nbsp; job_action &nbsp; &nbsp; &nbsp;=&gt; 'BEGIN ;updateStatus; END;',<br />
&nbsp; &nbsp; start_date &nbsp; &nbsp; &nbsp;=&gt; SYSTIMESTAMP,<br />
&nbsp; &nbsp; repeat_interval =&gt; 'freq=minutely; bysecond=0;',<br />
&nbsp; &nbsp; end_date &nbsp; &nbsp; &nbsp; &nbsp;=&gt; NULL,<br />
&nbsp; &nbsp; enabled &nbsp; &nbsp; &nbsp; &nbsp; =&gt; TRUE,<br />
&nbsp; auto_drop &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt; &nbsp; FALSE,<br />
&nbsp; &nbsp; comments &nbsp; &nbsp; &nbsp; &nbsp;=&gt; 'Job defined entirely by the CREATE JOB procedure.');<br />
&nbsp; &nbsp; end;<br />
<br />
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?
</div>
</div>


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

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?

Have you checked to make sure your stored procedure runs properly by itself and updates the status?

If so, have you run the job manually and verified that the status is being updated?

If so, have you run the job manually every minute (for a few minutes) and verified that the status is being updated?

How to Create job and run job in ORACLE

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

BEGIN
  -- Job defined entirely by the CREATE JOB procedure.
  DBMS_SCHEDULER.create_job (
    job_name        =&gt; &#39;Update_Status&#39;,
    job_type        =&gt; &#39;PLSQL_BLOCK&#39;,
    job_action      =&gt; &#39;BEGIN ;updateStatus; END;&#39;,
    start_date      =&gt; SYSTIMESTAMP,
    repeat_interval =&gt; &#39;freq=minutely; bysecond=0;&#39;,
    end_date        =&gt; NULL,
    enabled         =&gt; TRUE,
  auto_drop          =&gt;   FALSE,
    comments        =&gt; &#39;Job defined entirely by the CREATE JOB procedure.&#39;);
    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?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.