DBA Hub

📋Steps in this guide1/1

Definition of job in dbms_jobs

-- First get the job_id and owner; select job,log_user,schema_user from dba_jobs;

oracle configurationintermediate
by OracleDba
13 views
1

Definition of job in dbms_jobs

-- 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

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
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;
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!