Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dbms_job.submit

Status
Not open for further replies.
DKL01

DKL01

Programmer
Sep 14, 2000
233
US
Hi,

I was wondering how to check the list of jobs available in Oracle using TOAD/SQL Plus. We are using dbms_job.submit in stored procedures to send jobs to queue. I really appreciate any ideas.

Thanks
 
Sort by date Sort by votes
It's very simple in TOAD - There is a JOBS tab in the Left Hand Side of the Schema Browser. Select that tab and view the jobs (have to be logged in as a DBA to see all the jobs submitted from all schemas).

If you don't see the JOBS tab, put your cursor in the tab area and right-click - JOBS should be in the list and you just need to select it, then the tab should appear.
 
Upvote 0 Downvote
I'm able to view jobs in TOAD. Thanks much !
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Scunningham99
  • Locked
  • Question
dbms_job.submit and isubmit
Replies
3
Views
207
lewisp
lewisp
kodaksmile
  • Locked
  • Question
dbms_job.submit
Replies
3
Views
142
kodaksmile
kodaksmile

Part and Inventory Search

Sponsor

Back
Top