Run them manually for the first time, or try dropping and recreating them.
Raj
-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!
-----Original Message-----
From: Ball, Terry [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 28, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject: Oracle Jobs not restarting after upgrade
Solaris 5.8 Oracle 8.1.6 upgrade to 9.2
We are testing an upgrade of Oracle from 8.1.6 to 9.2. There are several oracle jobs scheduled on this DB. Before we started the upgrade, all the jobs were broken (execute dbms_job.broken(201, true). The upgrade to 8.1.7 was done and then the migrate/upgrade to 9.2.0 was done. The jobs were then unbroken execute dbms_job.broken(201, false). But the jobs are not running. A select shows that the jobs are no longer broken, but is also shows that the last date they ran was just before the upgrade, with the next_date showing as the time it would have been scheduled before the upgrade. (I.e, if it ran on the first and was a daily job, it's next_date would be the second). We have tried issuing a change for the next date, but all that does is show a new next_date, it does not make the jobs run.
Is there a way to make these jobs start running again. I have looked in the manuals, but either I am missing something obvious, or am not looking in the right place. Any help or suggestions are appreciated. TIA.
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1800
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ball, Terry
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
