Solved

updating sql on a job in dba_scheduler_job

Posted on 2013-06-10
3
522 Views
Last Modified: 2013-06-10
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.
0
Comment
Question by:themeeper1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 38

Expert Comment

by:Gerwin Jansen, EE MVE
ID: 39235052
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.
0
 

Author Comment

by:themeeper1
ID: 39235084
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?
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39235106
You can change parameters with dbms_scheduler.set_attribute:
http://docs.oracle.com/cd/E11882_01/appdev.112/e25788/d_sched.htm#CIHDAIIH
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
use lov values 2 72
Oracle DB Slows After Datapump Until Next Reboot 27 131
oracle numeric condition check 4 37
populate value based on what is selected in lov 2 36
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question