Getting Job details in analytics

[Romain]

Hello,

What is the table that contains job details ?
We would need to have an analytics that could contain (for UserImportJob) : 
  - Start Date of the job
  - End date of the job
  - Number of users in feed

Regards,

[rushikeshvartak · Accepted solution]

SELECT EC.JOBNAME,EC.EXTERNALCONNECTION,EC.SAVRESPONSE AS RESPONSE, EC.JOBSTARTDATE,EC.JOBENDDATE, SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(REPLACE(IL.LOGDATAASXML,'','@'),'','&'),'&',1),'@',-1) AS TOTAL_IMPORT_TIME FROM ECMIMPORTJOB EC, IMPORTLOG IL WHERE EC.JOBID = IL.JOBID AND EC.JOBNAME = 'USERIMPORTJOB' AND EC.SAVRESPONSE = 'SUCCESS';

[Romain]

Perfect, IMPORTLOG was the table I was looking for !