|
Each utility listed below describes the problem it is designed to solve. For details on how the tool functions (syntax, return codes, error messages, etc.) click on the name of the script listed that solves that particular problem.
AutoSys specific - Generate a report of all alarms without using the GUI
In a production environment, it is always important to keep track of the alarms that are generated within AutoSys. If you are dialing in remotely over a modem, it is not practical to enter the AutoSys GUI to view the alarms. With this script, you can retrieve the same information that appears on the AutoSys Alarms Screen without entering the GUI. This could also be useful for users that do not have access to X-Windows software and therefore cannot access the AutoSys GUI.
|
|
|
Prints status of jobs and job names.
|
|
|
|
Formats the output file with page breaks for easy printing and viewing.
|
AutoSys specific - Output the tables of the AutoSys database
To acheive optimal performance, auditors might want to know the contents of all the tables of the AutoSys Database. Use the first group of scripts mentioned below to retrieve all this information.
|
|
|
Outputs all the contents for all tables in the AutoSys Database
|
|
|
|
Formats the output file with page breaks for easy printing and viewing.
|
Or perhaps an auditor would like to know what the contents of a specific AutoSys table. Use the second group of scripts mentioned below to retrieve just this information.
|
|
|
Outputs the contents of a user-specified table from the AutoSys database to the screen or file.
|
|
|
|
Formats the output file with page breaks for easy printing and viewing.
|
AutoSys Specific - Report jobs and their status at a given time
Many times in a production environment, it is useful to know how many jobs are in a given status, so that better load balancing can be performed. If you know how many jobs are in RUNNING state at a given time, you'll have a better idea how to balance the load of your production environment. This can also be used accurately to total the number of jobs in your production environment, without boxes, if using AutoSys to obtain a true count of the number of jobs.
|
|
|
This syprl script gives the total number of jobs in the database (does not include boxes as jobs). Can also be broken down to the number of jobs that are in any given state (i.e. running, inactive, activated, failure, success, etc.). This is very useful in report format to balance the workload in a production environment.
|
|
|
|
Formats the output file with page breaks for easy printing and viewing.
|
Custom reports made easy from any database
Do you lack the time or resources to create custom reports? This utility makes the creation of custom reports a snap. Just specify what you want in a file and submit it to the utility to select the information needed in the format desired. Anyone will be able to generate complex analysis off the database of any scheduler.
|
|
|
Submits a file or command that generates a report from the database of the scheduler.
|
|
|
|
Formats the output file with page breaks for easy printing and viewing.
|
Custom reports made easy from Sybase
Similar to the utility described above, these reporting scripts are designed specifically for generating complex analyses off a Sybase Database for any job scheduler.
|
|
|
Submits a file with Stored Procedures stored on it to the StoredProc.prl script.
|
| StoredProc.syprl |
|
Runs each Stored Procedure in the Sybase Database. |
|
|
|
Formats the output file with page breaks for easy printing and viewing.
|
Report jobs that run on a particular machine
How many times have you needed to take a production server off-line for immediate repair, but the machine processes several critical jobs? Use this tool to generate a report listing the jobs that run on this machine to easily track job changes and carry out updates.
|
|
|
Generates the list of jobs that run on that specified machine.
|
|
|
|
Formats the output file with page breaks for easy printing and viewing.
|
© 2002 Stirling Systems Group, LLC
All Rights Reserved.
|
