OraFAQ Forum: Server Administration » Creating/ Running jobs in oracle 9i for solaris

Home » RDBMS Server » Server Administration » Creating/ Running jobs in oracle 9i for solaris

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

Creating/ Running jobs in oracle 9i for solaris [message #135943]

Mon, 05 September 2005 01:21

abidali
Messages: 6
Registered: August 2005

Junior Member

Pls can anybody give me some tips as to how
1) to define a job in oracle9i for solaris
2) to schedule this job

Remember i hav prior expereince deploying jobs at windows platform but when i try it on (9i for ) solaris, the script does not work as it does not accept a submit job request.

Rgds,
Abid

Report message to a moderator

Re: Creating/ Running jobs in oracle 9i for solaris [message #136031 is a reply to message #135943]

Mon, 05 September 2005 08:26

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

Senior Member
Account Moderator

You can use DBMS_JOB to schedule job within database.
http://www.unix.org.ua/orelly/oracle/bipack/ch13_01.htm
Or
use an OS scheduler like crontab.
http://www.adminschoice.com/docs/crontab.htm

Report message to a moderator

Re: Creating/ Running jobs in oracle 9i for solaris [message #185019 is a reply to message #136031]

Sun, 30 July 2006 01:50

abidali
Messages: 6
Registered: August 2005

Junior Member

Dear Mahesh

Thanks a lot for your response.
Actually i had to do it at a clients server which they preferred doing themselves. Still its an important/valuable information for me.

Tanks a lot

Abid

Report message to a moderator