<div>
Using either SQL Developer or Toad, lookup the job, find the sql that is called. A job usually calls a function or stored procedure, you have to look into that.
</div>


Using either SQL Developer or Toad, lookup the job, find the sql that is called. A job usually calls a function or stored procedure, you have to look into that.

<div>
I see the job under sqldeveloper and the sql attached to it. How do I update the sql under job_action? I tried to do an update but received errors. Do I use dbms_scheduler and some sort of update statement to recreate that job?
</div>


I see the job under sqldeveloper and the sql attached to it. How do I update the sql under job_action? I tried to do an update but received errors. Do I use dbms_scheduler and some sort of update statement to recreate that job?

<div>
<div class="content wysiwyg-content">
I want to update the sql for a specific job under dba_scheduler_jobs but I have no access to Enterprise Manager. How would I go about updating this job?<br />
<br />
Thanks.
</div>
</div>


I want to update the sql for a specific job under dba_scheduler_jobs but I have no access to Enterprise Manager. How would I go about updating this job?

Thanks.

updating sql on a job in dba_scheduler_job

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.