Home » RDBMS Server » Backup & Recovery » Scheduler on Particular Condition (oracle, 10g, windows xp)
Scheduler on Particular Condition [message #555565] Fri, 25 May 2012 02:27 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,


I need a help on the below task.

I have to fire "EXPORT BACKUP COMMAND" depend on the EOD Process.

ie:

1) We have a EOD Process, which would be completing between 8pm to 6am.
2) After this EOD process, we have to take EXPORT Backup.
3) The above mentioned steps are being done manually.

Now i want to make them automated:

4) ie if the EOD process completed between the mentioned time. then Export command should be run, otherwise should not happen.

Kindly guide me.

Regards
Muktha
Re: Scheduler on Particular Condition [message #555574 is a reply to message #555565] Fri, 25 May 2012 03:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ What is EOD process?
2/ Export is NOT a database backup (strategy).

Regards
Michel

Re: Scheduler on Particular Condition [message #555588 is a reply to message #555574] Fri, 25 May 2012 05:32 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

1) EOD means End Of the Day process, which is being done by another Dept. Out Export should be taken after that process completion.
2) Fine, But I want to do EXPORT of the Database.

Thanks

Regards
Muktha
Re: Scheduler on Particular Condition [message #555591 is a reply to message #555588] Fri, 25 May 2012 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So do it.

Regards
Michel
Re: Scheduler on Particular Condition [message #555751 is a reply to message #555591] Mon, 28 May 2012 05:35 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Still I am facing the problem.

1) My Actual Work to be done is:
I have saved this SQL file as:'D:\Oracle\Binoj\muthu_krishnan\Rman_test_script.sql'
insert into rman_test
values
('Muthu');

commit;


2) In a Batch file I have entered the below commands.
set oracle_sid=ladsl
sqlplus abc/abc$123 @D:\Oracle\Binoj\muthu_krishnan\Rman_test_script.sql


3) Now I am creating a Scheduler as below.

begin
dbms_scheduler.create_job(
   job_name=>'RMAN_TICKER_TEST',
   job_type=>'EXECUTABLE',
   job_action=>'D:\Oracle\Binoj\muthu_krishnan\Rman_test_bat.bat',
   enabled=>True,
   comments=>'To check the RMAN TICKER file existence');
end;


4) Everything is fine, but the table is not getting row inserted at the particular time i have mentioned in the Scheduler.


Regards
Muktha
Re: Scheduler on Particular Condition [message #555752 is a reply to message #555751] Mon, 28 May 2012 05:39 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Can't tell for sure, but - from my own experience, JOB_ACTION should be calling Windows' CMD which then calls your batch script.

Here's a topic ( Run external job with DBMS_SCHEDULER) where I asked for help; read it, you might find it useful.

P.S. Ah, yes ... exactly as I thought. Barbara already pointed you to that discussion (here; didn't you read it?).

[Updated on: Mon, 28 May 2012 05:48]

Report message to a moderator

Re: Scheduler on Particular Condition [message #555756 is a reply to message #555752] Mon, 28 May 2012 06:27 Go to previous message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Little,Michel,

Sorry for the mis-communication.

Everything was correct, But the problem was I didn't Start the "ORACLEJOBSCHEDULER" in the SERVICES. MSC.

Thanks for the help.
Muktha
Previous Topic: recover truncate table data
Next Topic: Execute BATCH FILE through PLSQL
Goto Forum:
  


Current Time: Fri Mar 29 00:29:11 CDT 2024