Extract all the jobs with all the details like scheduled time

[Shwet01]

Hi All,

I need one urgent help, i am trying to extract all the jobs available in system with below information-

1. Job Name

2.Schedule time

3.Status of job

4.Endpoint name associated with the job

5.Jobtype

6.connection and file name attached to that job?

Is it possible to get these values. I tried with query but did not worked. 

If anyone has any query for this or somewhat related to this can you please share.

Thanks

Shwet

[PremMahadikar]

Hi @Shwet01 ,

Try this query:

select 
	e.JOBNAME as 'Jobname',
	e.TRIGGERNAME as 'Trigger Name', 
	FROM_UNIXTIME(qt.NEXT_FIRE_TIME / 1000) AS 'Next Schedule time',
	e.SAVRESPONSE as 'Status of job', 
	e.SYSTEMNAME as 'Endpoint',
	e.TRIGGERTYPE,
	e.EXTERNALCONNECTION as 'Connection'
from 
	ecmimportjob e left outer join  qrtz_triggers qt on qt.TRIGGER_NAME=e.TRIGGERNAME 
group by 
	e.JOBNAME, qt.NEXT_FIRE_TIME