Home » RDBMS Server » Server Administration » Scheduling
Scheduling [message #180633] Tue, 04 July 2006 08:32 Go to next message
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 ...
Re: Scheduling [message #180637 is a reply to message #180633] Tue, 04 July 2006 08:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Look into DBMS_JOB
Re: Scheduling [message #180641 is a reply to message #180633] Tue, 04 July 2006 09:05 Go to previous messageGo to next message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
thanks for quick response.

could you plz type the complete syntax.

Thanks
Re: Scheduling [message #180644 is a reply to message #180641] Tue, 04 July 2006 09:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous messageGo to next message
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.
Re: Scheduling [message #180672 is a reply to message #180664] Tue, 04 July 2006 14:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.



Re: Scheduling [message #180673 is a reply to message #180633] Tue, 04 July 2006 14:24 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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?
Re: Scheduling [message #180677 is a reply to message #180664] Tue, 04 July 2006 14:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: Scheduling [message #308653 is a reply to message #180672] Tue, 25 March 2008 02:35 Go to previous messageGo to next message
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.


Re: Scheduling [message #308658 is a reply to message #308653] Tue, 25 March 2008 02:43 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't or in so complex and roundabout way that it is wrong to do it.

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


Current Time: Sat Dec 03 09:47:26 CST 2016

Total time taken to generate the page: 0.17781 seconds