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;
Monday, January 7, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment