Export job history for the audit purpose.

[Santosh]

Hello all, we have a requirement to export the job history logs for few months. How can I get that information. I don't see the export option on the job but only on the completed task. Also, on the logs i chose service as "Job", it gave me the log of 14 days back only. Any leads?

[rushikeshvartak]

You can analytics report.

SELECT 
    JOBID,
    COMENTS,
    EXTERNALCONNECTION,
    JOBENDDATE 'JOB END',
    JOBSTARTDATE 'JOB START',
    JOBNAME,
    SAVRESPONSE,
    SYSTEMNAME,
    UPDATEUSER,
    IPADDRESS,
    JOBGROUP,
    TRIGGERNAME,
    TRIGGERTYPE
FROM ecmimportjob 
WHERE JOBSTARTDATE >= NOW() - INTERVAL 14 DAY;

[Santosh]

Thank you for the response. I would have to retrieve the all the jobs history for maybe 90+ days. Do I just plug in number of days on interval?

[rushikeshvartak]

SELECT 
    JOBID,
    COMENTS,
    EXTERNALCONNECTION,
    JOBENDDATE AS 'JOB END',
    JOBSTARTDATE AS 'JOB START',
    JOBNAME,
    SAVRESPONSE,
    SYSTEMNAME,
    UPDATEUSER,
    IPADDRESS,
    JOBGROUP,
    TRIGGERNAME,
    TRIGGERTYPE
FROM ecmimportjob 
WHERE JOBSTARTDATE >= NOW() - INTERVAL 90 DAY;

[Santosh]

Thank you for that I was able to get that already. I needed all Job including data import and provisioning and this seems to be pulling heavy data from the Analytics and gives the message "background job running, will email once the report is ready"

[rushikeshvartak]

Data will be huge you can split and query per 30/15 days 

[rushikeshvartak · Accepted solution]

You can remove coments section 

SELECT 
    JOBID,
    EXTERNALCONNECTION,
    JOBENDDATE AS 'JOB END',
    JOBSTARTDATE AS 'JOB START',
    JOBNAME,
    SAVRESPONSE,
    SYSTEMNAME,
    UPDATEUSER,
    IPADDRESS,
    JOBGROUP,
    TRIGGERNAME,
    TRIGGERTYPE
FROM ecmimportjob 
WHERE JOBSTARTDATE >= NOW() - INTERVAL 90 DAY;