Viewing or Modifying Event Properties

Display or change the properties of the selected event.

Prerequisites

Database Version	Event Privileges
SAP Sybase IQ 15.3 and 15.4	View event properties – None required. Modify event comment or properties – Requires DBA authority.
SAP Sybase IQ 16.0	View event properties only – None required. Modify event properties – Requires one of: MANAGE ANY EVENT system privilege. ALTER ANY OBJECT system privilege. Modify event comment only – Requires one of: MANAGE ANY EVENT system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege COMMENT ANY OBJECT system privilege

Database Version

Event Privileges

SAP Sybase IQ 15.3 and 15.4

View event properties – None required.

Modify event comment or properties – Requires DBA authority.

SAP Sybase IQ 16.0

View event properties only – None required.

Modify event properties – Requires one of:

MANAGE ANY EVENT system privilege.
ALTER ANY OBJECT system privilege.

Modify event comment only – Requires one of:

MANAGE ANY EVENT system privilege
CREATE ANY OBJECT system privilege
ALTER ANY OBJECT system privilege
COMMENT ANY OBJECT system privilege

The SAP Sybase IQ resource is authenticated and running.
In a multiplex configuration, the coordinator node is running.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the Administration Console, expand IQ Servers > Compiled Objects > Events.
Select an events from the right pane, click the arrow to the right of the name and select Properties.
The Event Properties view appears.

View or modify the properties.

Area	Description
General	Name – (Read-only) Name of the event. Owner – (Read-only) Name of the owner of the event. Running – (Read-only) Indicates whether the event is running. Enabled – Select the check box to execute the event when the scheduled time, trigger condition or manual command occurs. Location – (Read-only) Indicates where the event will run. Valid values are: Execute at all databases – Executes the event at any and all remote locations. Execute at the consolidated databases only –For databases involved in SQL Remote replication, this executes the event at the consolidated database only, and not at any of the remote locations. Execute at the remote databases only – For databases involved in SQL Remote replication, this executes the event at the remote database(s) only, and not at the consolidated database. Next scheduled time – (Read-only) The time next time the event is scheduled to run. Comment – Add an optional comment about the event.
SQL	Displays the SQL statements that are executed when the event is triggered. If you edit the SQL code, click Apply before leaving the page.
Schedules	Use the New, Edit and Delete buttons to manage the event's schedules.
Conditions	System Event – From the drop down list, view or change the system event which triggers the event. Conditions – (Optional) Set one or more trigger conditions that must be satisfied, in addition to the system event, in order to trigger the event. Use the New, Edit and Delete buttons to manage the trigger conditions.

Click OK to save any changes, and exit the Event Properties view.