oracle list jobs

Hello coders! In this tutorial I have shared the details about “oracle list jobs”. Okay, let’s move on to the post.

oracle list jobs

SELECT OWNER, JOB_NAME, ENABLED, JOB_CLASS, NEXT_RUN_DATE
FROM DBA_SCHEDULER_JOBS
WHERE OWNER NOT IN ('SYS')
ORDER BY ENABLED, OWNER, JOB_NAME;

-- Running jobs:
SELECT OWNER, JOB_NAME, JOB_SUBNAME, JOB_STYLE, SESSION_ID, SLAVE_PROCESS_ID, 
	ELAPSED_TIME, CPU_USED 
FROM DBA_SCHEDULER_RUNNING_JOBS
ORDER BY OWNER, JOB_NAME;

Conclusion

I hope this post helps you to know about “oracle list jobs”. If you have any doubts regarding this article please let us know via the comment section. Share this post with your friends and family via social networks.

Hi, I'm Ranjith a full-time Blogger, YouTuber, Affiliate Marketer, & founder of Coder Diksha. Here, I post about programming to help developers.

Share on:

Leave a Comment