?
Solved

updating sql on a job in dba_scheduler_job

Posted on 2013-06-10
3
Medium Priority
?
526 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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to recover a database from a user managed backup

650 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