Hello Arsalan,
by creating oracle job it give error the details like below
Kindly guide me
window 2008
Oracle 11G R2
----------
Begin
Dbms_Scheduler.Drop_Job (Job_Name => 'DAILY_BACKUP');
END;
/
------For credential I give os user name and password
begin
dbms_scheduler.create_credential(
credential_name => 'EXTERNAL_JOB',
username => 'arsala',
password => 'aone#13.af');
end;
/
BEGIN
DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'DAILY_BACKUP',
job_type => 'EXECUTABLE', --'PLSQL_BLOCK',
job_action => 'c:\backup.bat',
number_of_arguments => 0,
start_date => SYSTIMESTAMP,
repeat_interval =>'FREQ=DAILY; BYDAY=SAT,SUN,MON,TUE,WED,THU; BYHOUR=22',
end_date => NULL,
enabled => TRUE,
auto_drop => FALSE,
credential_name => 'EXTERNAL_JOBS',
comments => 'This job is used to tranfer updated data from prod db to dwh db every day 10 PM exclude friday'
);
END;
/
begin
dbms_scheduler.run_job(job_name=>'DAILY_BACKUP',USE_CURRENT_SESSION=>true); -- true is default
end;
/
ORA-27369: job of type EXECUTABLE failed with exit code: The storage control blocks were destroyed.
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 2
Rman script path
backup.bat
Locked
