Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Find the database job that via sql text

Hemant SakpalJul 28 2023

Hi Team,

OS: RHEL 7

DB: 19.19

I have to track down the job name from the sql querty that I have but I am unable to do so. I have used the below methods to find it out but it is giving blank output.

select * from dba_jobs where upper(what) like '%sql_text%';

Please let me know if there is any alternate way to find it.

Thanks!

Comments
Post Details
Added on Jul 28 2023
2 comments
774 views