I do know how to write RMAN Scripts but am not sure how to automate the running of those scripts in the Unix as well as the Windows enviornment. any help is appreciated.
Printable View
I do know how to write RMAN Scripts but am not sure how to automate the running of those scripts in the Unix as well as the Windows enviornment. any help is appreciated.
man cron
yeahQuote:
Originally posted by davey23uk
man cron
cron man
or in windows you need to be where it's AT
What is AT
C:\Documents and Settings\sm900038\Desktop>at /?
The AT command schedules commands and programs to run on a computer at
a specified time and date. The Schedule service must be running to use
the AT command.
AT [\\computername] [ [id] [/DELETE] | /DELETE [/YES]]
AT [\\computername] time [/INTERACTIVE]
[ /EVERY:date[,...] | /NEXT:date[,...]] "command"
\\computername Specifies a remote computer. Commands are scheduled on the
local computer if this parameter is omitted.
id Is an identification number assigned to a scheduled
command.
/delete Cancels a scheduled command. If id is omitted, all the
scheduled commands on the computer are canceled.
/yes Used with cancel all jobs command when no further
confirmation is desired.
time Specifies the time when command is to run.
/interactive Allows the job to interact with the desktop of the user
who is logged on at the time the job runs.
/every:date[,...] Runs the command on each specified day(s) of the week or
month. If date is omitted, the current day of the month
is assumed.
/next:date[,...] Runs the specified command on the next occurrence of the
day (for example, next Thursday). If date is omitted, the
current day of the month is assumed.
"command" Is the Windows NT command, or batch program to be run.
C:\Documents and Settings\sm900038\Desktop>
thanks stmontgo for the detailed response. It is a lot of help!
submit the job using something like this.....
at every 1:00 /every monday c:\backups\rman_bkp.bat
CRON, AT :-)
How about using PL/SQL?
Can you use PL/SQL to schedule RMAN without using Java or external proc...? Dont think so!