[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 530
  • Last Modified:

updating sql on a job in dba_scheduler_job

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
themeeper1
Asked:
themeeper1
1 Solution
 
Gerwin Jansen, EE MVETopic Advisor Commented:
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
 
themeeper1Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now