The following SELECT statement retrieves the start time, end time, and row counts for FastLoad or TPT Load jobs submitted by USER1 since December 1, 2013:
SELECT UtilityName, LSN, JobStartTime, JobEndTime, RowsInserted
FROM td_metric_svc.dbqlutilityV
WHERE UserName = 'USER1'
AND (UtilityName = 'FASTLOAD' OR
UtilityName = 'TPTLOAD')
AND JobStartTime > '2013-12-01'
ORDER BY JobStartTime;
Result:
UtilityName LSN JobStartTime JobEndTime RowsInserted ----------- --- -------------------------- -------------------------- ------------ FASTLOAD 47 2013-12-02 09:19:22.150000 2013-12-02 09:30:59.670000 100,000 FASTLOAD 48 2013-12-02 09:19:24.250000 2013-12-02 09:30:44.820000 100,000 TPTLOAD 54 2013-12-02 10:07:41.700000 2013-12-02 10:07:48.940000 81,920