OraFAQ Forum: SQL & PL/SQL » Automatic abropting the long running job

Home » SQL & PL/SQL » SQL & PL/SQL » Automatic abropting the long running job (Oracle 12c)

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

Automatic abropting the long running job [message #676680]

Wed, 03 July 2019 11:33

sss111ind
Messages: 634
Registered: April 2012
Location: India

Senior Member

Dear All,

We have a scheduler which runs with inteval of 5 minutes. But sometimes it was running for a week .So is there any way to abropt the job automatically after it runs 30 minutes. I have searched and got max_run_duration attribute and set to 30 minutes however the job had not been stopped automatically.

Please help .

Report message to a moderator

[Message index]

		Automatic abropting the long running job By: sss111ind on Wed, 03 July 2019 11:33
		Re: Automatic abropting the long running job By: BlackSwan on Wed, 03 July 2019 11:39
		Re: Automatic abropting the long running job By: cookiemonster on Thu, 04 July 2019 04:49
		Re: Automatic abropting the long running job By: sss111ind on Thu, 04 July 2019 08:42
		Re: Automatic abropting the long running job By: John Watson on Thu, 04 July 2019 11:44
		Re: Automatic abropting the long running job By: sss111ind on Fri, 05 July 2019 09:47
		Re: Automatic abropting the long running job By: BlackSwan on Fri, 05 July 2019 11:44
		Re: Automatic abropting the long running job By: sss111ind on Sat, 06 July 2019 03:06
		Re: Automatic abropting the long running job By: BlackSwan on Sat, 06 July 2019 07:28

Previous Topic:	How to Create variable out of Table Type Variable!
Next Topic:	Trying to Report on Date Periods within a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 01:52:01 CDT 2024