Get Running SQL Log Job Session Stats

[Voodoo]

Hi,

I would like to retrieve the session summary stats for an active/running SQL log job for a report - pretty much all the information in the red boxes in the below picture.
I'm mainly interested in the number of successes, warnings, and errors, and the result of the last session for each individual VM/task in the log job.
This is for both agent and VM backup jobs.

I already have a script to list the overall result of a completed SQL log job, but can't work out how to do the above.




https://imgur.com/a/A9h5p4i

Thanks.

[david.domask]

Hi @Voodoo

post466985.html?hilit=log%20backup#p466985

Does this thread help you? You can get the sessions that way and then format the output as you desire.

[Voodoo]

Thanks David, that was exactly what I was after.

Don't know how I missed that post when searching.

[david.domask]

Happens I knew we had the code elsewhere on the forums and I just didn't have an active SQL Log backup job to test with, so I knew what to search.

Glad I could help, and good luck with scripting.