Step | Description |
1 | The service checks the current status of the notification. |
2 | If the notification is enabled, the service checks the forceDisable parameter. If forceDisable is false, the service reports the error. If forceDisable is true, the service disables the notification. |
3 | The service validates the schema against the notification's settings. The validation requires that the schema be in the same catalog that is configured with the notification and that the table, synonym, view, or alias, configured in the notification be in the schema. If the schema is not valid, the service throws an exception. |
4 | The service updates the notification property with the new schemas, and throws an exception if the input fields for the new schemas are not valid. |
5 | If the original notification state is enabled, the service enables the notification. |
nodeName | String. Required. Sets the name of the notification to be updated. |
forceDisable | Boolean. Required. If the value of this field is set to true, the service disables the notification that is in the enabled state. |
allSchemaChange | Record. Optional. Indicates that the update is to occur on every schema name in the notification. |
allSchemaChange.useCurrentSchema | Boolean. Optional. It sets all schema names to <current schema>. |
allSchemaChange.schemaName | String. Optional. Sets all schema names to the value of this field. |
schemaChanges | Record List. Optional. Makes individual schema changes, replacing the schema identified by the existingSchema field with the new name set in the newSchema field. |
schemaChanges.existingSchema | Record. Required. Identifies the schema name to change. |
schemaChanges.existingSchema.useCurrentSchema | Boolean.Optional. Identifies the <current schema>. |
schemaChanges.existingSchema.schemaName | String. Optional. Specifies an existing schema name for the schemaName field. |
schemaChanges.newSchema | Record. Required. Identifies an existing schema name that will replace all occurrences of existing schemas identified in the existingSchema field. |
schemaChanges.newSchema.useCurrentSchema | Boolean. Optional. Sets new schema names to <current schema>. |
schemaChanges.newSchema.schemaName | String. Optional. Sets new schema names to this name. |