RE: How to best schedule jobs in another schema?
Date: Fri, 12 Feb 2010 09:38:27 -0500
I have not tried this for creating new jobs, but what about using dbms_sys_sql?
Vlado Barun, M.Sc., OCE, OCP, MCP
Sr. Database Architect/Manager, Database Engineering and Operations Jewelry Television
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse Sent: Thursday, February 11, 2010 3:21 PM To: oracle-l_at_freelists.org
Subject: How to best schedule jobs in another schema?
Revisiting my post from 2008:
...I found a vague inference to a Scheduler job running as *creator* instead of *owner*:
Confusing and inconsistent with other Oracle security IMHO, but that's the way it works.
So how should one schedule jobs to run in another schema? The schemas I'm trying to run jobs in cannot be logged into for security purposes (have an invalid password). The only thing I can come up with is to write a DBMS_SCHEDULER wrapper package to be created in each schema, but this is a maintenance nightmare. Either that, or use a generic "execute immediate" proc in each schema, but the security implications of that should be obvious.
Anyone using DBMS_SCHEDULER to run jobs in another schema? How do you use it?
http://www.freelists.org/webpage/oracle-l Received on Fri Feb 12 2010 - 08:38:27 CST