How to identify a Job being executed?

Asked

Viewed 1,994 times

1

Hello.. I created a Job in ORACLE, where it runs a PROCEDURE, but I wanted to perform a SELECT, where I returned the status of this Job. Because I will use this information to return a reply to the user that the request he had previously made is being executed, and that he waits.

       select 
            job_name as nomeJob, 
            status as status 
        from 
            dba_scheduler_job_run_details
        where 
            job_name = 'JOB_QUE_EU_FIZ'

And you don’t return what I wanted. Could someone help me ?

sql database oracle select

  • Opa, welcome to Stackoverflow... Read this documentation that should help you: https://docs.oracle.com/html/E25494_01/scheduse008.htm

  • 1 what I usually do is to routinely send a log of execution by email to the user , plsql for sending e-mail available around the web 2 the view DBA_JOBS_RUNING lists the running Jobs 3 the view DBA_JOBS has a summary of the last and next execution https://Docs.oracle.com/html/E25494_01/scheduse008.htm

  • Thanks, in this link I managed to find the correct table to check the execution of Job.

1 answer

2


I was able to solve, as I was helped in the comments, now I’m performing the consultation in another table, to get the return of the execution of Job.

in this case, this table returns the active Obs, then just look for the name of the job I created.

Below is the code I’m using, in case I can help anyone else:

        select 
            job_name  
        from 
            user_scheduler_running_jobs 
        where 
            job_name = 'JOB_QUE_EU_FIZ';

Browser other questions tagged sql database oracle select

You are not signed in. Login or sign up in order to post.