Home » SQL & PL/SQL » SQL & PL/SQL » how to alter a package being called in a scheduled Job (10g)
how to alter a package being called in a scheduled Job [message #433722] Thu, 03 December 2009 16:23 Go to next message
pkirangi
Messages: 74
Registered: August 2005
Member
Hello All,

We have a scheduled job created using dbms_scheduler.
We need to change the package name used in the dbms_scheduler, without having to create a new job.
More specifically we need to alter the "JOB_ACTION" parameter(which is Package.procedure name) of dbms_schedular.create_job api. The "JOB_TYPE" parameter is PLSQL_BLOCK.

Thanks in Advance,
PHK
Re: how to alter a package being called in a scheduled Job [message #433728 is a reply to message #433722] Thu, 03 December 2009 19:41 Go to previous messageGo to next message
Kevin Meade
Messages: 2098
Registered: December 1999
Location: Connecticut USA
Senior Member
I have never used DBMS_SCHEDULER. But I recall from DBMS_JOBS that there was an api call to change the WHAT that was executed by the job. I have to image there is something similar.

As I review the package, there seem to be several routines that would provide the information you need and that will do what you need. Try doing a basick google on DBMS_SCHEDULER.

Good luck, Kevin
Re: how to alter a package being called in a scheduled Job [message #433765 is a reply to message #433722] Fri, 04 December 2009 02:58 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You probably want DBMS_SCHEDULER.SET_ATTRIBUTE

Why can't you just drop the job and create a new one
Re: how to alter a package being called in a scheduled Job [message #433862 is a reply to message #433765] Fri, 04 December 2009 10:36 Go to previous message
pkirangi
Messages: 74
Registered: August 2005
Member
Thanks Kevin/JRowbottom for you responses.

I checked the set_attribute, but it does not allow me to set the JOB_ACTION parameter.
I guess I will just drop and create it.

Thanks anyways
PHK
Previous Topic: pipe delimmited file without sql inside
Next Topic: sequence no higher than other
Goto Forum:
  


Current Time: Wed Sep 28 15:58:17 CDT 2016

Total time taken to generate the page: 0.09613 seconds