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. Modify event comment or properties – you must have DBA authority.
SAP Sybase IQ 16.0	View event properties only – none. Modify event properties – you must have one of: MANAGE ANY EVENT system privilege ALTER ANY OBJECT system privilege Modify event comment only – you must have 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.

Modify event comment or properties – you must have DBA authority.

SAP Sybase IQ 16.0

View event properties only – none.

Modify event properties – you must have one of:

MANAGE ANY EVENT system privilege
ALTER ANY OBJECT system privilege

Modify event comment only – you must have 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 left pane, expand IQ Servers > Compiled Objects, and then select Events.
Select an event from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > 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.

Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.