You use this program to:
add, delete, maintain and execute diagnostic script configurations
import and export scripts
This program can be accessed from the Administration tab in the SYSPRO Analytics Setup program.
| Field | Description |
|---|---|
| New | Add a new diagnostic script configuration. |
| Delete | Delete a diagnostic script configuration. |
| Save | Save a diagnostic script configuration. |
| Refresh | Refresh the list of existing diagnostic script configurations. |
| Execute | Execute the diagnostic script configuration. When you select this, the Select Target Database window is displayed. |
| Import | Import a diagnostic script from an XML file. |
| Export | Export a diagnostic script to an XML file. |
The Select Target Database window allows you to select the database and site for which you will run the script.
A list of available database names, sites and server names are displayed, allowing you to select the target database, site and server name.
Once you have made your selection, click the Execute button.
You add the information for a new Diagnostic and select the target database in this pane
| Field | Description |
|---|---|
| Diagnostic Details | |
| Description | Enter a description for the diagnostic script configuration. |
| Target | Select the target database that the script must be
executed against:
|
| Script type | This indicates the script type. Currently this can only be SQLScript. |
| Type | This indicates the type of diagnostic script configuration. Currently this is set to Custom by default, as no standard diagnostic script configurations exist. |
You can select the Script tab to view or enter the script for a new or existing Diagnostic.
| Field | Description |
|---|---|
| Open | Open a SQL script file
(*.sql). When the program loads the script file, it first clears the Scripts pane before displaying the script. |
| Open and append | Open a SQL script file (*.sql).
When the program loads the script file, it does not clear the Scripts pane, but appends the script to the existing contents of the pane. |