OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle JOB (Oracle 10g AIX)

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

Oracle JOB [message #490013]

Thu, 20 January 2011 10:47

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Hi ,
There was a job failure which i have fixed .How do i submit this job back again ? next run is tomorrow ,so i want to run this job once again today

tried dbms_job.run(job#) ,but its running in foreground.Any help ? Thanks

Report message to a moderator

Re: Oracle JOB [message #490015 is a reply to message #490013]

Thu, 20 January 2011 10:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

DBMS_JOB.NEXT_RUN

Report message to a moderator

Re: Oracle JOB [message #490018 is a reply to message #490015]

Thu, 20 January 2011 11:00

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

Senior Member
Account Moderator

or rather DBMS_JOB.NEXT_DATE

Regards
Michel

Report message to a moderator

Re: Oracle JOB [message #490020 is a reply to message #490015]

Thu, 20 January 2011 11:03

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

THANKS

Report message to a moderator

Previous Topic:	oracle 11g patch installation steps
Next Topic:	DBMS Scheduler jobs are not running

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:28:46 CST 2024