MaestroDBQ is an add-on for IBM's Tilovi Workload Scheduler. Not in any way intended to be a replacement for the service you currently have in place to create, edit and submit jobs within TWS. An add-on only. Allows read-only querying and reporting of all items within the TWS database (excluding passwords, current Symphony schedules, and historical stats). Let's face it - the Java Gui isn't the easiest thing in the world to get to grips with, and if all you wish to do is print a schedule, or query the details of a job, then using MaestroDBQ couldn't be simpler.

In fact, you won't need a course to use any of its features. Designed with simplicity in mind, once it's installed and configured, you really can jump in at the deep end and discover for yourself it's so shallow your short fat hairy legs are still dry! Really is that straightforward.

Is It Really That Simple?

Well, yes it is - unlike the Java Gui, which requires doctorate degrees in neurogenesis, metaphysics and Greek; all you'll need for this one, is a healthy susceptibility towards cheap and cheerful software. The Gui is split into three panes/windows. Left pane is the Elements View: a tree that lists every element in your TWS database (Workstations, Valid Schedules, Invalid Schedules, Valid Jobs, Invalid Jobs, Calendars, Parameters, Prompts and Resources). Middle pane is the Query Output Window, and contains the results of all queries and reports you decide to click on or run. Right pane displays Quick-Reports. In-built queries designed to make life easier - just select and run. For example: List all external dependencies of a schedule.

Bit More Detail?

Well, see those greyed icons near the top of the page? They represent the eight query sections within the Query Output Window of the program, and clicking them above, will take you to a page further describing each of these sections. For now tho, we'll just have a brief look at what they represent:

Workstation

Activated if you select a Workstation element from the tree Elements View, and provides a breakdown of each setting defined for that Workstation.

Schedule

Lists the contents of the Schedule selected from the Elements View. Keywords are highlighted for easier viewing.

Job

Displays the job definition items of the selected Job from the Elements View

Calendar

Displays all dates and variables associated with the calendar selected.

Parameter

Lists selected parameter(s).

Prompt

Lists selected prompt(s).

Resource

Lists selected resource(s).

Report

Displays the output of the last query made from the Quick-Reports pane. Reports are split by element, and you can switch between each group of built-in reports using the left/right buttons in the Quick-Reports pane. Currently, the following reports are selectable: List all CPU/Schedules, List Schedules/CPU and Highlight Duplicates, Find Search-String in Schedule Names, Display Full Internal Schedule Dependencies (sorted in order of execution), Display External Schedule Dependencies (sorted in order of execution), List all Workstation/Jobs, List Jobs/Workstation and Highlight Duplicates, Find Search-String in Job Names, Display Schedules containing Job Name, Find Search-String in Script/Command, List Schedules for Workstation, List Jobs for Workstation, List Classes, Find Schedules that use Calendar, List unused Calendars, List invalid Calendars, List valid Calendars, Find Schedules that use Resource, Check which Resources are in use, Find Jobs that use Parameter, Check which Parameters are in use, Find Schedules that use Prompt, Check which Prompts are in use.

So Why Freeware?

MaestroDBQ was a hobby development designed to make life a little easier within the TWS environment I supported at the time. You know what Operations chappies are like - can't be done in two clicks, they throw a wobbler! ;)

It's seen much use, and much appreciation within the NT/2K/XP/UNIX TWS V6.x, 7.x and 8.x environment it was designed for, and as I'm such a generous guy, I'm now passing it on to you on the understanding that If it works for you, then great! If it doesn't, then damn and blast! Still, thank your lucky stars you didn't pay for it, eh!? But... if you point me in the direction of the fault, and you ask nicely, then there's a good chance I'll take a look at it for you! Can't say fairer than that now, can I?

Finally...

This is just a simple Windows Executable designed to run on NT/2K/XP - it's freeware - no ads or spyware, and does not require an Internet connection, altho some kind of network connection to the TWS Master Domain would be a good idea, or at least some form of connection to where you're likely to store your database extracts (see Installation for details). It is stand-alone, manually installed (just drag and drop the exe to wherever you want to put it and create a shortcut), provides only read-only access to your TWS data, and shouldn't affect the running of any system it's placed on - of course, you use at your own risk (as they say), and enjoy!