You can change the approval method (switch option) for online scripts. Approval method determines how the switch proceeds for a live reorganization script or a partitioning script.
Approval method can be changed for online scripts that are waiting to run or waiting to be restarted. A change in approval method applies to all tables in a script for which the switch has not yet been made.
For more information about approval methods (also known as Switch Options), see Select Scripting Options and More About Scripting Options (LiveReorg).
To change approval method
When the switch option for a live reorganization script is Upon user approval, you must approve the switch for each table in the script. You can do this from the Scripts/Job Monitor or from its Live Reorg Detail pane using one of the following procedures.
To see if a table is waiting for the switch to be approved, check the Status Message column in Scripts/Job monitor. “Waiting for approval” is the status for a script when one of its tables is waiting for approval.
After you approve the switch for one table in a script, check to see when the next table is ready for the switch. How much time passes before approval is required depends on the size of the table being reorganized, the number and size of its indexes, and the level of activity against the table.
To approve the switch from the Scripts/Job Monitor
To approve the switch from Live Reorganization Detail
When you are away from the Space Manager client computer, you can monitor scheduled execution with email notifications from QSA. These alert you when scheduled execution fails. QSA sends an email immediately after a failure occurs.
Each email notification identifies script name, execution error, execution start and stop times, database server hostname, and Oracle SID for the database. The subject field displays “Script Failure Notice!”.
QSA emails notifications when its SENDMAIL parameters are configured. These parameters allow you to specify who should receive notifications. You can specify both a primary and a secondary recipient. A recipient can be an individual or an email group.
Important: Before you can use QSA’s email notification capability, Oracle’s UTL_SMTP package must be installed on the database server. The package must have access to an SMTP mail server or relay server.
Use the following procedure to enable email notification. To configure notifications for other events, see Configure Additional Notification Events.
To enable email notifications
Select Tools | Admin | Quest Server Agent | Manage Quest Server Agent Installation.
On the QSA Parameters page, set the following SENDMAIL parameters in order to enable email notifications (values are required for all parameters except SENDMAIL_TO1):
| QSA Parameter | Description |
|---|---|
| SENDMAIL_DOMAIN | Specifies the domain name of the mail server or relay server. For example: yourcompany.com. |
| SENDMAIL_HOST | Specifies the address or fully-qualified name of the mail server or relay server host, for example: www.quest.com. |
| SENDMAIL_PORT | Specifies the port number on which the mail server or relay server is listening. |
| SENDMAIL_FROM | Specifies who sent the email notification. The text string you enter should be the email address of an individual or group, such as Administrator@yourcompany.com. |
| SENDMAIL_TO | Specifies the email recipient. Must be the email address of an individual or group, such as DBA@yourcompany.com. The address must be valid. Only one address may be entered. |
| SENDMAIL_TO1 |
Specifies a second recipient for email notifications. To specify three or more recipients, insert a row for each recipient in the QUEST_EXEC_PARAMETER table, where NAME is SENDMAIL_TO# and VALUE is a valid email address. Each SENDMAIL_TO# entry should increment by 1; for example, SENDMAIL_TO3, SENDMAIL_TO4. If there is a break in the number sequence, emails are not sent to recipients after the break. If you delete a recipient row, update the NAME rows that follow so the number sequence is preserved. You can specify a maximum of 99 recipients. |
Note: To disable SMTP email notification, set the SENDMAIL_PORT value to "0".
You can monitor scheduled execution for reorgs using Simple Network Management Protocol (SNMP) Trap notifications from QSA. If you enable these notifications, QSA alerts you when a scheduled execution fails. QSA sends a notification immediately after a failure occurs.
Use the following procedure to enable SNMP trap notification. To configure notifications for other events, see Configure Additional Notification Events.
Note: In addition to using an SNMP trap watcher program, you can also use Quest Foglight® to receive SNMP notifications.
To enable SNMP Trap notifications
Select Tools | Admin | Quest Server Agent | Manage Quest Server Agent Installation.
On the QSA Parameters page, set the following SNMP parameters in order to enable SNMP trap notifications.
| QSA Parameter | Description |
|---|---|
| SNMP_TO_HOST | Enter the host name for the SNMP monitor. |
| SNMP_PORT | Enter the port number that the SNMP monitor is listening on. |
| SNMP_COMMUNITY | Enter the name of your SNMP community (or any unique string value). |
Note: To disable SNMP trap notification, set the SNMP_PORT value to "0".
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
