dbms_scheduler
Dear buddies,
Felt its better to use a new thread instead of continuing the old one as I have created a new scheduler.
begin
dbms_scheduler.create_job(job_name => 'Test',
job_type => 'EXECUTABLE',
job_action => 'F:\MainDB\MainDBBackup.bat',
start_date => '02-Aug-2010 2.30.00 PM',
repeat_interval => 'FREQ=DAILY; INTERVAL=1',
comments => 'Dev Backup',
auto_drop => false,
enabled => TRUE);
end;
select ADDITIONAL_INFO from dba_scheduler_job_run_details
where job_name = 'Test'; -- null
and it doesn't run.
Let me give an overview on the settings in the control panel:
-------------------------------------------------------------------------------------
TimeZone: (GMT +08.00) Kuala Lumpur, Singapore
Current Time Zone: Malaya Peninsula Standard Time
DATE: 2nd August 2010 with the right TIME
Windows Scheduler:
-----------------------------
Windows Scheduled Task set to run at 1am but doesn't run on all days. Not sure why.
The output of dba_scheduler_jobs:
OWNER :SYS
JOB_NAME :TEST
JOB_SUBNAME :
JOB_CREATOR :SYS
CLIENT_ID :
GLOBAL_UID :
PROGRAM_OWNER :
PROGRAM_NAME :
JOB_TYPE :EXECUTABLE
JOB_ACTION :F:\MainDB\MainDBBackup.bat
NUMBER_OF_ARGUMENTS :0
SCHEDULE_OWNER :
SCHEDULE_NAME :
SCHEDULE_TYPE :CALENDAR
START_DATE :02-AUG-20 10.02.30.000000 PM +08:00
REPEAT_INTERVAL :FREQ=DAILY; INTERVAL=1
EVENT_QUEUE_OWNER :EVENT_QUEUE_NAME
EVENT_QUEUE_AGENT :
EVENT_CONDITION :
EVENT_RULE :
END_DATE :
JOB_CLASS DEFAULT_JOB_CLASS :
ENABLED :TRUE
AUTO_DROP :FALSE
RESTARTABLE :FALSE
STATE :SCHEDULED
JOB_PRIORITY :3
RUN_COUNT :0
MAX_RUNS :0
FAILURE_COUNT :
MAX_FAILURES :
RETRY_COUNT :0
LAST_START_DATE :
LAST_RUN_DURATION :
NEXT_RUN_DATE :02-AUG-20 10.02.30.000000 PM +08:00
SCHEDULE_LIMIT :
MAX_RUN_DURATION :
LOGGING_LEVEL :RUNS
STOP_ON_WINDOW_CLOSE :FALSE
INSTANCE_STICKINESS :TRUE
RAISE_EVENTS :
SYSTEM :TRUE
JOB_WEIGHT :1
NLS_ENV :NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA'
NLS_NUMERIC_CHARACTERS='.,' NLS_CALENDAR='GREGORIAN' NLS_DATE_FORMAT='DD-MON-RR'
NLS_DATE_LANGUAGE='AMERICAN' NLS_SORT='BINARY' NLS_TIME_FORMAT='HH.MI.SSXFF AM'
NLS_TIMESTAMP_FORMAT='DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT='HH.MI.SSXFF AM TZR'
NLS_TIMESTAMP_TZ_FORMAT='DD-MON-RR HH.MI.SSXFF AM TZR' NLS_DUAL_CURRENCY='$' NLS_COMP='BINARY'
NLS_LENGTH_SEMANTICS='BYTE' NLS_NCHAR_CONV_EXCP='FALSE'
SOURCE :
DESTINATION :
COMMENTS :Dev Backup
FLAGS :18909264
The scripts bat files:
MainDBBackup.bat
--------------------------
set ORACLE_SID=MainDB
sqlplus/nolog @MainDBBackup.sql
MainDBBackup.sql
-------------------------
connect sys/password as sysdba;
alter system switch logfile;
alter system archive log current;
$Rman target sys/password CMDFILE MainDB.rcv LOG MainDB_outfile.txt;
maindb.rcv
----------------
RUN {
backup database format='F:\MainDB\%U_%I_%T.bkp' tag="everyday_full_bkup"
plus archivelog format='F:\MainDB\Arch%U_%I_%T.arc' tag="arcbkp";
backup current controlfile;
restore database validate;
crosscheck backup;
crosscheck archivelog all;
}
exit
---------------------
If there is something else that I should furnish, please do let me know.
Really hope someone could guide me on how to fix this problem.
Thank You.
Nith
Edited by: user645399 on Aug 10, 2010 1:32 PM