Definition of job in dbms_jobs - Oracle Database Script. -- First get the job_id and owner; select job,log_user,schema_user from dba_jobs; 743,DBATEST --- connect to the owner , and get the definition of the job alter session set current_schema=DBATEST; set serveroutput on SQL> DECLARE callstr VARCHAR2(500); BEGIN dbms_job.user_export(743, callstr); dbms_output.put_line(callstr); END; /
-- First get the job_id and owner; select job,log_user,schema_user from dba_jobs; 743,DBATEST --- connect to the owner , and get the definition of the job alter session set current_schema=DBATEST; set serveroutput on SQL> DECLARE callstr VARCHAR2(500); BEGIN dbms_job.user_export(743, callstr); dbms_output.put_line(callstr); END; /