OPENROWSET is an option.

http://msdn.microsoft.com/en-us/library/ms190312.aspx

whats the schema for closedJobSums?

OK, I misread your question - I have a server side trace that gathers this info. why the reluctance for a SST? Mine gathers DL info and that is...

Absolutely. Save the trace ouput to a file, then open the file in profiler. Find the DL event in the listing of events, right click on the event...

My understanding is that if you use the built in MS maintenance plans, SQL is aware of which node is active and which is not.

One thing to keep...

Seven SQL Agent Jobs you should be running[/url]

Do you have the SQL server browser service running?

Your welcome Dave!

That info is in sysjobsteps

Does the job create an output file with more information?

Anything in the event logs? Can you try connecting with SQLCMD?

Thanks!

Not the most efficient solution....

DECLARE @currentTime DATETIME

SET @currentTime = GETDATE()

SELECT CAST(DATEPART(year,@currentTime) AS CHAR(4))

+ CASE WHEN (DATEPART(month,@currentTime)) > 10 then (CAST(DATEPART(month,@currentTime) AS CHAR(2)))

ELSE '0' + CAST(DATEPART(month,@currentTime) AS CHAR(1)) END...

Is the SQL server pingable?

The name of your machine.