OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Scheduling

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

Scheduling [message #180633]

Tue, 04 July 2006 08:32

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

Hello Everyone!

I want to schedule my backup job....or any job in oracle......is there any built-in procedure for that....
I dont want to use OS Scheduling......

thanks in advance ...

Report message to a moderator

Re: Scheduling [message #180637 is a reply to message #180633]

Tue, 04 July 2006 08:49

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Look into DBMS_JOB

Report message to a moderator

Re: Scheduling [message #180641 is a reply to message #180633]

Tue, 04 July 2006 09:05

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

thanks for quick response.

could you plz type the complete syntax.

Thanks

Report message to a moderator

Re: Scheduling [message #180644 is a reply to message #180641]

Tue, 04 July 2006 09:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>could you plz type the complete syntax.

No. I will not.
Teaching the 'syntax' is beyond the scope of any forum. You need to put some effort on your side.
All information is found in documentation.
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_job.htm#999107
To supplement,
Search this site. You will find many examples on all scenarios.
Google yourself. More examples. May be your question is already answered.

[Updated on: Tue, 04 July 2006 14:31]

Report message to a moderator

Scheduling [message #180664 is a reply to message #180633]

Tue, 04 July 2006 11:57

it_me24
Messages: 167
Registered: March 2006
Location: delhi

Senior Member

I went thru the link......but I did not get the concept how to run a perticular job at a perticular point of time....
suppose my requirement is i want to schedule backup strategy in such a way that ORACLE should automatically take a backup everyday at 4 pm....I don't want to use OEM for this purpose.

Thanks.

Report message to a moderator

Re: Scheduling [message #180672 is a reply to message #180664]

Tue, 04 July 2006 14:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You may NOT want to use DBMS_JOB for backup related jobs or anything directly related to OS. It will just add another level of complexity which you do not have to deal with.
This is best done in CRONJOB or any OS Scheduler.
Because with DBMS_JOB (a pl/sql package), you need to write a wrapper to execut OS commands (using OCI or java).
>> ORACLE should automatically take a backup everyday at 4 pm
Define 'backup'?
How are you 'backing up'?
By 'backup' I consider only RMAN backup and it would very clumsy to have a pl/sql wrapper for RMAN.

Report message to a moderator

Re: Scheduling [message #180673 is a reply to message #180633]

Tue, 04 July 2006 14:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I went thru the link......but I did not get the concept how to run a perticular job at a perticular point of time....
What part did you actually read & not understand?
Do you honestly expect us to do your homework for you?
How do you expect to learn anything if you are unwilling to do your own research & expect to be spoon fed?

Report message to a moderator

Re: Scheduling [message #180677 is a reply to message #180664]

Tue, 04 July 2006 14:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>but I did not get the concept how to run a perticular job at a perticular point of time
As said before, You may want to search the forum.
THere are many examples. Like this
http://www.orafaq.com/forum/m/167789/42800/?srch=dbms_job+example#msg_167789

Report message to a moderator

Re: Scheduling [message #308653 is a reply to message #180672]

Tue, 25 March 2008 02:35

bhagawandotcom
Messages: 2
Registered: September 2007

Junior Member

Hi,
I want to take backup daily at 9:00 am.So I want to use dbms_job
using oci.But I don't have idea about this.so pls,help me.

Report message to a moderator

Re: Scheduling [message #308658 is a reply to message #308653]

Tue, 25 March 2008 02:43

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

Senior Member
Account Moderator

You can't or in so complex and roundabout way that it is wrong to do it.

Regards
Michel

Report message to a moderator

Previous Topic:	How to move all data from +dg1 to +dg2?
Next Topic:	unable to write to file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 04:02:10 CST 2024