Wednesday, December 14, 2011

How to get the currently executing Job Id?

Use the below PL/SQL block to get the currently executing job id.

DECLARE
v_job_id NUMBER;
BEGIN
v_job_id := CDR_PUB_EXE_RUNTIME.getCurrentlyExecutingJobId(1);
EXCEPTION
WHEN OTHERS THEN
NULL;
END;

No comments:

Post a Comment