Home » RDBMS Server » Server Administration » How to check what Procedure is calling in database jobs? (oracle12c)
How to check what Procedure is calling in database jobs? [message #658588] Tue, 20 December 2016 12:43 Go to next message
shrinika
Messages: 283
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..
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
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"?

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 Go to previous messageGo to next message
cookiemonster
Messages: 13014
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Any feedback is appreciated.

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 Go to previous messageGo to next message
shrinika
Messages: 283
Registered: April 2008
Senior Member
Thanks! dba_scheduler_programs helps.
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 Go to previous message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

How? What was the actual problem and question?

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


Current Time: Tue Feb 20 23:55:07 CST 2018

Total time taken to generate the page: 0.02384 seconds