OraFAQ Forum: Backup & Recovery » Scheduler on Particular Condition

Home » RDBMS Server » Backup & Recovery » Scheduler on Particular Condition (oracle, 10g, windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Scheduler on Particular Condition [message #555565]

Fri, 25 May 2012 02:27

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

Report message to a moderator

Re: Scheduler on Particular Condition [message #555574 is a reply to message #555565]

Fri, 25 May 2012 03:04

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ What is EOD process?
2/ Export is NOT a database backup (strategy).

Regards
Michel

Report message to a moderator

Re: Scheduler on Particular Condition [message #555588 is a reply to message #555574]

Fri, 25 May 2012 05:32

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

Report message to a moderator

Re: Scheduler on Particular Condition [message #555591 is a reply to message #555588]

Fri, 25 May 2012 06:23

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So do it.

Regards
Michel

Report message to a moderator

Re: Scheduler on Particular Condition [message #555751 is a reply to message #555591]

Mon, 28 May 2012 05:35

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

Report message to a moderator

Re: Scheduler on Particular Condition [message #555752 is a reply to message #555751]

Mon, 28 May 2012 05:39

Littlefoot
Messages: 21823
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

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

Report message to a moderator

Previous Topic:	recover truncate table data
Next Topic:	Execute BATCH FILE through PLSQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 21:10:48 CST 2025