Script to View All Currently Running and Scheduled Jobs on Your Deployment Servers

Have you ever wanted to see all of the jobs that are currently running or are scheduled to run on each of your Deployment Servers? How about the status of key services and the last bootup time as well? That's what this hta script offers, all in one interface.

To get started, unzip the attached script. Open the DSConsoleStatus.hta file in notepad or your favorite script editor. Scroll down to about line 324 where it says "Enter list of servers below". You'll want to modify this list of servers to reflect your environment. Enter the names of your Deployment Servers. You may need to specify the SQL named instance, which is what I have specified in the first 2 example servers by using "DS1\sqlexpress", sqlexpress being the named instance on server DS1. After you get all of your servers in the list, then save the file and close it.

Double click the DSConsoleStatus.hta file and select the servers that you want to query from the list. Then hit query jobs to get a list of all of the currently running and scheduled jobs on all of those servers you selected. You can also query the health of servers by clicking Query Health instead of Query Jobs. This takes a lot longer to do, so be patient. It will query the status of the DS Data Manager service, the DS DB management server, express server service, and MS SQL service. It will also let you know the last time the server booted up.

You can automatically refresh your queries every 60 seconds by pressing the Start Refreshing button after performing either a job query or a health query. It will then auto refresh whichever query that you just made. To stop the auto refresh click Stop Refreshing.