Get SQL job status for all servers.

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jason Crider SSCertifiable Points: 6019 More actions · Answer 1

You create the column Jmessage initially but don't pull over the message to populate it.

I'm playing with it now and modified this piece of code with the addition in bold.

--Change run duration into something you can recognize (hh:mm:ss)

, LEFT(RIGHT('000000' + CAST(run_duration AS VARCHAR(10)),6),2) + ':' +

SUBSTRING(RIGHT('000000' + CAST(run_duration AS VARCHAR(10)),6),3,2) + ':' +

RIGHT(RIGHT('000000' + CAST(run_duration AS VARCHAR(10)),6),2)

, sjh.message