Unfortunately it does not return any records.

Thank you for your help.

Thanks.

I need it to return 1 record for each job that is currently executing.

The following code does not work for In Progress.

CASE h.Run_Status

...

rador (3/12/2014)

---

Did you find an answer to this problem? I have 2 instances of SQL Server running with what appears to be the exact same configuration and one sends...

I need to revise the following query do display an jobs that are currently running.

What would be the best way to do this?

-- SELECT *

--FROM msdb.dbo.sysjobactivity

SELECT DISTINCT

'CYP_BI'...

Thank you!

ok, this is what I have so far and it works. I had to focus on something...

Thanks.

I will need a LEFT JOIN on sysjobs because I want them to show up regardless if they have...

I tried adding the following from the 1st query to the second query and I get an error invalid column run_date, run_time and run-duration.

msdb.dbo.Agent_datetime(Run_Date, Run_Time) AS Run_Datetime,

Dateadd(second, Datediff(second, 0, msdb.dbo.Agent_datetime(19000101,...

I appreciate it. Could I get the...

Thanks but can I get the entire code?

It does not work.

awesome:cool:

Thank you very much for all of the help.

Thank you very much everyone!

Well a decision was made to use the msdb databases (more than one server UNION & Linked Server) to work with what I have generated.

I still need to figure how...

Disregard.

The requirements changed they are going to take a static Excel Document and generate XML Strings.

My apologies.