InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 14:13:03 GMT20http://www.sqlservercentral.com/Forums/Topic853083-146-1.aspxThis will give you the current status of jobs running, saw it on a forum site I use it to monitor long running jobs, they are still running so no historyexecute master.dbo.xp_sqlagent_enum_jobs 1, 'garbage' -- doesn't seem to matter what you put hereAndrewMon, 25 Jan 2010 15:20:26 GMTandrewkane17http://www.sqlservercentral.com/Forums/Topic853083-146-1.aspx[quote][b]muthukkumaran (1/25/2010)[/b][hr]Right click job name-->view history...[/quote]The OP wants it deliberately from the query... I guess the OP might be aware of this..Mon, 25 Jan 2010 11:03:17 GMTBru Medishettyhttp://www.sqlservercentral.com/Forums/Topic853083-146-1.aspx[quote][b]haichells (1/25/2010)[/b][hr]Hi,Can anyone please help me the query to get the Status of Jobs in a server.. i.e for ex Job A - Executing ,Job B- Failed ,Job C - Success etc.,Thanks in Advance![/quote]Right click job name-->view history...Mon, 25 Jan 2010 10:59:04 GMTmuthukkumaran Kaliyamoorthyhttp://www.sqlservercentral.com/Forums/Topic853083-146-1.aspxTo get the Job status information, we need to use the relevant information from two job related tables namely sysjobs and sysjobhistory.The run_status column of sysjobhistory has the current status of the job.You can refer to the following script:select distinct j.Name as "Job Name",h.run_date as LastStatusDate, case h.run_status when 0 then 'Failed' when 1 then 'Successful' when 3 then 'Cancelled' when 4 then 'Executing' end as JobStatusfrom msdb.dbo.sysJobHistory h, msdb.dbo.sysJobs jwhere j.job_id = h.job_id and h.run_date = (select max(hi.run_date) from msdb.dbo.sysJobHistory hi where h.job_id = hi.job_id)Hope this will help you...Mon, 25 Jan 2010 10:46:33 GMTKumari Punamhttp://www.sqlservercentral.com/Forums/Topic853083-146-1.aspxHi,Can anyone please help me the query to get the Status of Jobs in a server.. i.e for ex Job A - Executing ,Job B- Failed ,Job C - Success etc.,Thanks in Advance!Mon, 25 Jan 2010 09:21:23 GMThaichells