how to alter a package being called in a scheduled Job [message #433722] |
Thu, 03 December 2009 16:23  |
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
|
|
|
|
|
|