AdTempus

Select all Jobs

    Select  * from Job order by name

List all jobs, execution date, status

SELECT
job.Name
,EHI.ExecutionStart DateAndTime
--,EHI.Status
,RS.stringText Status
FROM Job inner join [executionHistoryItem] EHI on job.oid = jobOID
inner join [reportStrings] RS on EHI.status = RS.stringID
where executionStart > 'YYYY-MM-DD 00:00:00.000'
order by Name, executionStart

Jobs status from a particular date

SELECT distinct 

job.Name

, CAST(EHI.ExecutionStart AS DATE) [Date] -- EHI.ExecutionStart DateAndTime

--,EHI.Status

,RS.stringText Status

FROM Job inner join [executionHistoryItem] EHI on job.oid = jobOID 

inner join [reportStrings] RS on EHI.status = RS.stringID

where executionStart > '2020-06-13 00:00:00.000'