Monday, January 7, 2008

Tracking Data Integrator Loads

This SQL script (run against the tridata schema) will provide all Data Integrator loads, the status of the load, and which user initiated the upload:

select ibs.created_date "STARTED_DATE",
ibs.updated_date "FINISHED_DATE",
ibs.object_state "STATUS",
mp.sys_useraccount "USER_ACCOUNT",
ibs.spec_name "UPLOAD_NAME"
from ibs_spec ibs, t_myprofile mp
where ibs.spec_template_id = 106548 and
ibs.created_by = mp.spec_id
order by 1 desc;

No comments: