File	Date	Author	Commit
README	2014-05-05	Ralf Lange	[ed8d1c] modified: README
SCHEDULER_BACKUP.html	2014-05-05	Ralf Lange	[b7d608] modified: SCHEDULER_BACKUP.html
SCHEDULER_BACKUP.sql	2014-04-25	Ralf Lange	[2a5fc1] better formatting of status procedure
schedulernew.sql	2014-05-05	Ralf Lange	[ec5a47] modified: schedulernew.sql

Read Me

PL/SQL Package SCHEDULER_BACKUP Readme
======================================

Installation:
-------------
bash> sqlplus / as sysdba
SQL*Plus> @SCHEDULER_BACKUP
SQL*Plus> begin
scheduler_backup.setup(os_username=>'oracle',os_password=>'onlyknownbyme',
                       db_username=>'sys',db_password=>'alsoonlyknownbyme');
end;
/

Usage:
------
After the SCHEDULER_BACKUP package has been installed into the database,
use SQL Developer to open the package specification. Change the commands
for daily and weekly backup, the schedule, the flags (descriptions
are in the package specification) to adapt to your needs. Recompile the
package.
Caution: Changing the package specification does not change the Scheduler
objects (Credentials, Jobs, Programs) the package has created. To implement
changes you made in the specification, call

SQL*Plus> exec scheduler_backup.setup

without parameters from SQL*Plus. This will recreate all objects except the
Credentials, thus implementing changes you made in the package.

Load schedulernew.sql into a SQL Developer worksheet. It contains examples how
to use the package and SQL queries to get the state of this package's scheduler
objects. It is even possible to retrieve RMAN output through SQL.