OraFAQ Forum: Server Administration » Database scheduler to re-schedule the job

Home » RDBMS Server » Server Administration » Database scheduler to re-schedule the job

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

Database scheduler to re-schedule the job [message #655753]

Mon, 12 September 2016 00:40

samiran_cts
Messages: 52
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

Report message to a moderator

Re: Database scheduler to re-schedule the job [message #655754 is a reply to message #655753]

Mon, 12 September 2016 00:50

samiran_cts
Messages: 52
Registered: January 2012

Member

Also it is showing as the JOB FAILED and JOB_BROKEN when I am querying DBA_SCHEDULER_JOBS

Report message to a moderator

Re: Database scheduler to re-schedule the job [message #655755 is a reply to message #655754]

Mon, 12 September 2016 00:57

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

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

samiran_cts
Messages: 52
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

Report message to a moderator

Re: Database scheduler to re-schedule the job [message #655758 is a reply to message #655757]

Mon, 12 September 2016 02:41

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

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.

Report message to a moderator

Re: Database scheduler to re-schedule the job [message #655759 is a reply to message #655758]

Mon, 12 September 2016 02:48

samiran_cts
Messages: 52
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.

Report message to a moderator

Re: Database scheduler to re-schedule the job [message #655760 is a reply to message #655759]

Mon, 12 September 2016 03:04

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

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?

Report message to a moderator

Re: Database scheduler to re-schedule the job [message #655762 is a reply to message #655760]

Mon, 12 September 2016 04:23

samiran_cts
Messages: 52
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.

Report message to a moderator

Re: Database scheduler to re-schedule the job [message #655763 is a reply to message #655762]

Mon, 12 September 2016 04:25

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

Senior Member
Account Moderator

It appears you didn't read what I posted.

Report message to a moderator

Re: Database scheduler to re-schedule the job [message #655770 is a reply to message #655762]

Mon, 12 September 2016 06:33

EdStevens
Messages: 1376
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?

Report message to a moderator

Re: Database scheduler to re-schedule the job [message #655774 is a reply to message #655762]

Mon, 12 September 2016 08:52

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

Report message to a moderator

Re: Database scheduler to re-schedule the job [message #655775 is a reply to message #655774]

Mon, 12 September 2016 09:15

samiran_cts
Messages: 52
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.

Report message to a moderator

Re: Database scheduler to re-schedule the job [message #655776 is a reply to message #655775]

Mon, 12 September 2016 09:20

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 18:45:01 CST 2024