Database Administration (MOSC)

MOSC Banner

Execute shell script within Oracle 11g using Scheduler

edited Apr 5, 2018 5:02AM in Database Administration (MOSC) 8 commentsAnswered

Bonjour Community,

  I have a script that dump certain schema from production database and then reload said data to the dev database.  To do that, I'm using a shell script that I want to be lauched, on command, from the user, it seems the most recommended method to fire shell scripts, from what I read anyway.

The problem is, to lauch an "EXECUTABLE" type of scheduler job, the user need the "create job" and "create external job" privileges.  From where I stand, I could make a LOT of mess with such privileges, create job that generates script that could make a lot of damage!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center