Check Agent Job Status From Different Servers with PowershellPosted: June 30, 2016
Rob Swell has a handy script to retrieve agent job running status from multiple servers.
You can find the script from his bolg.
You just need to update the file location and server list (one server in one line text file) and run the script from Powershell window. You will get an Excel file open to show your the slow moving progress.
If you want to use this script to run as an agent job, you may need to set proper permission to allow powershell user through agent job to access Excel COM.
Here is how to change the Identity to The interactive user:
From Administrative Tools>>Component Services > Computers > My Computer > DCOM Config >> Microsoft Excel application (right click ) > Properties
> Identity > Select The Interactive User (by default, it was The launching user) > Click OK.