![]() ![]() The JOB_TYPE of EXTERNAL_SCRIPT is similar to an EXECUTABLE job, except that it allows you to build a script on the fly and run it as the JOB_ACTION, as if it were an existing shell script. With these in place, we can look at the three new job scripts. correct OS user on the database server. The following permissions are necessary to allow the "TEST" user to run the examples in this article.Īll the examples use the following credential to allow them to authenticate to the OS user that runs the job.ĬONN Create a credential so script is run as the They will also need credentials to access an OS user. As a result, they require the CREATE JOB and CREATE EXTERNAL JOB privileges. They don't provide anything that was not already possible, but they reduce the likelihood of mistakes and make task-specific schedules much clearer.Īll three of the new script jobs are essentially external jobs for running shell scripts, SQL*Plus or RMAN. Script jobs are all about improving the ease of use of the Oracle Scheduler. DBMS_CREDENTIAL : Persist Database and OS Credentials in Oracle Database 12c Release 1 (12.1).Data Guard Database Rolling Upgrade Support.In Oracle Database 12c Release 1, the scheduler has added more functionality, with a focus on ease of use. The Oracle scheduler ( DBMS_SCHEDULER) has been enhanced with each release since it was introduced in Oracle 10g Release 1. ![]() Home » Articles » 12c » Here Scheduler (DBMS_SCHEDULER) Enhancements in Oracle Database 12c Release 1 (12.1) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |