Home » RDBMS Server » Server Administration » Database scheduler to re-schedule the job
Database scheduler to re-schedule the job [message #655753] Mon, 12 September 2016 00:40 Go to next message
samiran_cts
Messages: 46
Registered: January 2012
Member
Hello Sir,

I have a job running but failed and the next_run_date is schedule for 2nd july which won't start now as the date is well gone. How to restart the job to a particular date say 15 jul ?

Regards,
Samiran
Re: Database scheduler to re-schedule the job [message #655754 is a reply to message #655753] Mon, 12 September 2016 00:50 Go to previous messageGo to next message
samiran_cts
Messages: 46
Registered: January 2012
Member
Also it is showing as the JOB FAILED and JOB_BROKEN when I am querying DBA_SCHEDULER_JOBS
Re: Database scheduler to re-schedule the job [message #655755 is a reply to message #655754] Mon, 12 September 2016 00:57 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Copy and paste the row from DBA_SCHEDULER_JOBS for your job.
Use T.Kyte's print_table function for this.
Don't forget to format it.

[Updated on: Mon, 12 September 2016 01:00]

Report message to a moderator

Re: Database scheduler to re-schedule the job [message #655757 is a reply to message #655755] Mon, 12 September 2016 02:07 Go to previous messageGo to next message
samiran_cts
Messages: 46
Registered: January 2012
Member
select OWNER
      ,JOB_NAME
      ,PROGRAM_OWNER
      ,PROGRAM_NAME
      ,START_DATE
      ,LAST_START_DATE
      ,LAST_RUN_DURATION
      ,NEXT_RUN_DATE
      ,ENABLED
      ,RESTARTABLE
      ,STATE
      ,RUN_COUNT
      ,MAX_RUNS
      ,FAILURE_COUNT
      ,MAX_FAILURES
      ,LOGGING_LEVEL
      ,RAISE_EVENTS
      ,SCHEDULE_LIMIT
from DBA_SCHEDULER_JOBS
where JOB_NAME = 'PARTITION_MAINTENANCE_JOB'
 
 
OWNER    JOB_NAME                       OWNER    PROGRAM_NAME       START_DATE                           LAST_START_DATE
-------- ------------------------------ -------- ------------------ ------------------------------------ -------------------------------------------------------------------------
LAST_RUN_DURATION                    NEXT_RUN_DATE                        ENABL RESTA STATE       RUN_COUNT   MAX_RUNS FAILURE_COUNT MAX_FAILURES LOGGING_LEV RAISE_EVENTS              SCHEDULE_LIMIT
------------------------------------ ------------------------------------ ----- ----- ---------- ---------- ---------- ------------- ------------ ----------- ------------------------- --------------
APRPC_APP PARTITION_MAINTENANCE_JOB      APRPC_APP PART_MAINTENANCE   11-JUL-09 07.00.00.000000 PM -05:00  01-JUL-16 07.00.00.628922 PM -05:00
+000000000 00:03:21.936897           02-JUL-16 07.00.00.600000 PM -05:00  TRUE  FALSE SCHEDULED          90                        0           15 OFF         JOB_FAILED,JOB_BROKEN     +000 01:00:00
Re: Database scheduler to re-schedule the job [message #655758 is a reply to message #655757] Mon, 12 September 2016 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why didn't you do what I said: "Use T.Kyte's print_table function for this"?

Check alert.log to know the reason of the failures as well as ALL_SCHEDULER_JOB_RUN_DETAILS ALL_SCHEDULER_JOB_LOG and but for what I can see the job is not broken.

Re: Database scheduler to re-schedule the job [message #655759 is a reply to message #655758] Mon, 12 September 2016 02:48 Go to previous messageGo to next message
samiran_cts
Messages: 46
Registered: January 2012
Member
Sir, I don't have access to the environment so couldn't "Use T.Kyte's print_table function for this".

Can I use EXEC DBMS_JOB.BROKEN(<job id>,FALSE);

Is it possible to reschedule it again after the use of the above statement.
Re: Database scheduler to re-schedule the job [message #655760 is a reply to message #655759] Mon, 12 September 2016 03:04 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I don't have access to the environment
What does this mean? You have access as you execute some SQL commands!

Quote:
Can I use EXEC DBMS_JOB.BROKEN(<job id>,FALSE);
Why do you want to execute this?

Re: Database scheduler to re-schedule the job [message #655762 is a reply to message #655760] Mon, 12 September 2016 04:23 Go to previous messageGo to next message
samiran_cts
Messages: 46
Registered: January 2012
Member
I also don't have access to run any SQL statement. For that I need to raise ticket to other team for that. I want to execute EXEC DBMS_JOB.BROKEN(<Job id>,FALSE) to remove the broken status. It appears that the job failed and broken.
Re: Database scheduler to re-schedule the job [message #655763 is a reply to message #655762] Mon, 12 September 2016 04:25 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It appears you didn't read what I posted.

Re: Database scheduler to re-schedule the job [message #655770 is a reply to message #655762] Mon, 12 September 2016 06:33 Go to previous messageGo to next message
EdStevens
Messages: 985
Registered: September 2013
Senior Member
samiran_cts wrote on Mon, 12 September 2016 04:23
I also don't have access to run any SQL statement. For that I need to raise ticket to other team for that. I want to execute EXEC DBMS_JOB.BROKEN(<Job id>,FALSE) to remove the broken status. It appears that the job failed and broken.
So how did you get what you posted in msg # 655757?
Re: Database scheduler to re-schedule the job [message #655774 is a reply to message #655762] Mon, 12 September 2016 08:52 Go to previous messageGo to next message
bpeasland
Messages: 51
Registered: February 2015
Location: United States
Member

If you are not in a position to execute a SQL statement, then you won't be able to execute that package call either. Have your DBA team manually start the job.

Cheers,
Brian
Re: Database scheduler to re-schedule the job [message #655775 is a reply to message #655774] Mon, 12 September 2016 09:15 Go to previous messageGo to next message
samiran_cts
Messages: 46
Registered: January 2012
Member
The above query i received from the other team only who has got access. They sent me the query result. My job profile demand to give instruction to the other team so that the problem can be solved. Now the job is not running at all. So I suggested them to execute this EXEC DBMS_JOB.BROKEN(<job id>,FALSE); I am not sure if I am going in the right path so wanted all yours expert opinions based on this limited information I have with me.
Re: Database scheduler to re-schedule the job [message #655776 is a reply to message #655775] Mon, 12 September 2016 09:20 Go to previous message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I already answered to these questions.
If you are not qualified to do DBA job I advise you to tell it to your manager and "the other team".
A DBA must have access to the database otherwise he can't do his job.

[Updated on: Mon, 12 September 2016 09:21]

Report message to a moderator

Previous Topic: install oracle 11g r2 on aix with san storage
Next Topic: How to apply patch in Oracle VISION Instance
Goto Forum:
  


Current Time: Mon Oct 22 03:06:18 CDT 2018