publisher burst log view

Question

Summary

Content

hello,

For the burst mail,  we can check the status for each sent in bi publisher like the following

is there a way to access theses informations with SQL query from outside publisher ?

best regards

jeanmarc

jmarc · Answer

ok,

i find the solution with  the blob column DELIVERY_PARAMETERS in XMLP_SCHED_DELIVERY

select REGEXP_SUBSTR(V_BLOBTOCLOB(DELIVERY_PARAMETERS),'d_emaild_to=.*') from BI12C_BIPLATFORM.XMLP_SCHED_DELIVERY

create or replace function v_blobtoclob(v_blob_in in blob)

return clob is

v_file_clob clob;

v_file_size integer := dbms_lob.lobmaxsize;

v_dest_offset integer := 1;

v_src_offset integer := 1;

v_blob_csid number := dbms_lob.default_csid;

v_lang_context number := dbms_lob.default_lang_ctx;

v_warning integer;

v_length number;

begin

dbms_lob.createtemporary(v_file_clob, true);

dbms_lob.converttoclob(v_file_clob,

v_blob_in,

v_file_size,

v_dest_offset,

v_src_offset,

v_blob_csid,

v_lang_context,

v_warning);

return v_file_clob;

exception

when others then

dbms_output.put_line('Error found');

end;

/

jmarc · Answer

sorry , i don't find any email adress in these table

YGUTTIKONDA · Answer

Please review the following note Need the Names of Scheduler Tables in 11.1 of BI Publisher (Doc ID 1618405.1), all the schedule information is stored in the listed tables

• XMLP_SCHED_DATA

• XMLP_SCHED_DELIVERY

• XMLP_SCHED_JOB

• XMLP_SCHED_OUTPUT

Hope this Helps