OraFAQ Forum: Server Administration » How to check what Procedure is calling in database jobs?

Home » RDBMS Server » Server Administration » How to check what Procedure is calling in database jobs? (oracle12c)

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

How to check what Procedure is calling in database jobs? [message #658588]

Tue, 20 December 2016 12:43

shrinika
Messages: 306
Registered: April 2008

Senior Member

I am trying to figure out how to check what procedure is calling in the database jobs..

DBA_scheduler_jobs & DBA_SCHEDULER_JOB_LOG are not providing this info.

I know we can check through tool(sql developer or Toad).

Do we have equivalent dictionary view to accomplish the same?

Any help is appreciated..

Report message to a moderator

Re: How to check what Procedure is calling in database jobs? [message #658590 is a reply to message #658588]

Tue, 20 December 2016 13:44

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

Senior Member
Account Moderator

What do you mean by "what procedure is calling in the database jobs.."?
Or do you mean "what procedure is called by database jobs"?

Report message to a moderator

Re: How to check what Procedure is calling in database jobs? [message #658606 is a reply to message #658590]

Wed, 21 December 2016 03:28

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

Assuming you meant Michel's revised version of the question dba_scheduler_programs is the view you want.

Report message to a moderator

Re: How to check what Procedure is calling in database jobs? [message #658684 is a reply to message #658588]

Fri, 23 December 2016 02:52

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

Senior Member
Account Moderator

Any feedback is appreciated.

Report message to a moderator

Re: How to check what Procedure is calling in database jobs? [message #659708 is a reply to message #658684]

Fri, 27 January 2017 14:35

shrinika
Messages: 306
Registered: April 2008

Senior Member

Thanks! dba_scheduler_programs helps.

Report message to a moderator

Re: How to check what Procedure is calling in database jobs? [message #659710 is a reply to message #659708]

Fri, 27 January 2017 15:08

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

Senior Member
Account Moderator

How? What was the actual problem and question?

Report message to a moderator

Previous Topic:	Clarification Required On Query
Next Topic:	ROLE not working as expected

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 16:34:34 CST 2024