< Back
Set-AMDatabaseCondition
Post
NAME Set-AMDatabaseCondition
SYNOPSIS
Sets properties of an AutoMate Enterprise database condition.
SYNTAX
Set-AMDatabaseCondition [-InputObject] <Object> [[-DatabaseType] {SQL | Oracle}] [[-Server] <String>]
[[-NotificationPort] <Int32>] [[-Database] <String>] [[-Table] <String>] [[-UserName] <String>] [-Insert]
[-Delete] [-Update] [-Drop] [-Alter] [-Wait] [[-Timeout] <Int32>] [[-TimeoutUnit] {Seconds | Minutes | Hours |
Days | Milliseconds}] [[-TriggerAfter] <Int32>] [[-Notes] <String>] [[-CompletionState] {InDevelopment | Testing |
Production | Archive}] [-WhatIf] [-Confirm] [<CommonParameters>]
DESCRIPTION
Set-AMDatabaseCondition modifies an existing database condition.
PARAMETERS
-InputObject <Object>
The condition to modify.
Required? true
Position? 1
Default value
Accept pipeline input? true (ByValue)
Accept wildcard characters? false
-DatabaseType
The type of database to monitor: SQL (Microsoft) or Oracle.
Required? false
Position? 2
Default value SQL
Accept pipeline input? false
Accept wildcard characters? false
-Server <String>
The name of the database server to be monitored.
Required? false
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-NotificationPort <Int32>
Indicates the port number that the notification listener listens on for database notifications. If the port
number is set to -1 (default), a random port number is assigned to the listener when started.
Required? false
Position? 4
Default value -1
Accept pipeline input? false
Accept wildcard characters? false
-Database <String>
The name of the database to be monitored.
Required? false
Position? 5
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Table <String>
The database table which holds the data element(s) to be monitored. This value must include the schema name
and table name separated by a dot (.) entered in the following format (minus the brackets):
[Schema_Name].[Table_Name].
Required? false
Position? 6
Default value
Accept pipeline input? false
Accept wildcard characters? false
-UserName <String>
The username used to authenticate with the database.
Required? false
Position? 7
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Insert [<SwitchParameter>]
If set, the condition evaluates to TRUE when an INSERT is performed on the specified database.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Delete [<SwitchParameter>]
If set, the condition evaluates to TRUE when an DELETE is performed on the specified database.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Update [<SwitchParameter>]
If set, the condition evaluates to TRUE when an UPDATE is performed on the specified database.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Drop [<SwitchParameter>]
If set, the condition evaluates to TRUE when an DROP is performed on the specified database.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Alter [<SwitchParameter>]
If set, the condition evaluates to TRUE when an ALTER is performed on the specified database.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Wait [<SwitchParameter>]
Wait for the condition, or evaluate immediately.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Timeout <Int32>
If wait is specified, the amount of time before the condition times out.
Required? false
Position? 8
Default value 0
Accept pipeline input? false
Accept wildcard characters? false
-TimeoutUnit
The unit for Timeout (Seconds by default).
Required? false
Position? 9
Default value
Accept pipeline input? false
Accept wildcard characters? false
-TriggerAfter <Int32>
The number of times the condition should occur before the trigger fires.
Required? false
Position? 10
Default value 0
Accept pipeline input? false
Accept wildcard characters? false
-Notes <String>
The new notes to set on the object.
Required? false
Position? 11
Default value
Accept pipeline input? false
Accept wildcard characters? false
-CompletionState
The completion state (staging level) to set on the object.
Required? false
Position? 12
Default value
Accept pipeline input? false
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
RELATED LINKS
https://github.com/AutomatePS/AutomatePS
SYNOPSIS
Sets properties of an AutoMate Enterprise database condition.
SYNTAX
Set-AMDatabaseCondition [-InputObject] <Object> [[-DatabaseType] {SQL | Oracle}] [[-Server] <String>]
[[-NotificationPort] <Int32>] [[-Database] <String>] [[-Table] <String>] [[-UserName] <String>] [-Insert]
[-Delete] [-Update] [-Drop] [-Alter] [-Wait] [[-Timeout] <Int32>] [[-TimeoutUnit] {Seconds | Minutes | Hours |
Days | Milliseconds}] [[-TriggerAfter] <Int32>] [[-Notes] <String>] [[-CompletionState] {InDevelopment | Testing |
Production | Archive}] [-WhatIf] [-Confirm] [<CommonParameters>]
DESCRIPTION
Set-AMDatabaseCondition modifies an existing database condition.
PARAMETERS
-InputObject <Object>
The condition to modify.
Required? true
Position? 1
Default value
Accept pipeline input? true (ByValue)
Accept wildcard characters? false
-DatabaseType
The type of database to monitor: SQL (Microsoft) or Oracle.
Required? false
Position? 2
Default value SQL
Accept pipeline input? false
Accept wildcard characters? false
-Server <String>
The name of the database server to be monitored.
Required? false
Position? 3
Default value
Accept pipeline input? false
Accept wildcard characters? false
-NotificationPort <Int32>
Indicates the port number that the notification listener listens on for database notifications. If the port
number is set to -1 (default), a random port number is assigned to the listener when started.
Required? false
Position? 4
Default value -1
Accept pipeline input? false
Accept wildcard characters? false
-Database <String>
The name of the database to be monitored.
Required? false
Position? 5
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Table <String>
The database table which holds the data element(s) to be monitored. This value must include the schema name
and table name separated by a dot (.) entered in the following format (minus the brackets):
[Schema_Name].[Table_Name].
Required? false
Position? 6
Default value
Accept pipeline input? false
Accept wildcard characters? false
-UserName <String>
The username used to authenticate with the database.
Required? false
Position? 7
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Insert [<SwitchParameter>]
If set, the condition evaluates to TRUE when an INSERT is performed on the specified database.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Delete [<SwitchParameter>]
If set, the condition evaluates to TRUE when an DELETE is performed on the specified database.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Update [<SwitchParameter>]
If set, the condition evaluates to TRUE when an UPDATE is performed on the specified database.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Drop [<SwitchParameter>]
If set, the condition evaluates to TRUE when an DROP is performed on the specified database.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Alter [<SwitchParameter>]
If set, the condition evaluates to TRUE when an ALTER is performed on the specified database.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Wait [<SwitchParameter>]
Wait for the condition, or evaluate immediately.
Required? false
Position? named
Default value False
Accept pipeline input? false
Accept wildcard characters? false
-Timeout <Int32>
If wait is specified, the amount of time before the condition times out.
Required? false
Position? 8
Default value 0
Accept pipeline input? false
Accept wildcard characters? false
-TimeoutUnit
The unit for Timeout (Seconds by default).
Required? false
Position? 9
Default value
Accept pipeline input? false
Accept wildcard characters? false
-TriggerAfter <Int32>
The number of times the condition should occur before the trigger fires.
Required? false
Position? 10
Default value 0
Accept pipeline input? false
Accept wildcard characters? false
-Notes <String>
The new notes to set on the object.
Required? false
Position? 11
Default value
Accept pipeline input? false
Accept wildcard characters? false
-CompletionState
The completion state (staging level) to set on the object.
Required? false
Position? 12
Default value
Accept pipeline input? false
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Required? false
Position? named
Default value
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
OUTPUTS
RELATED LINKS
https://github.com/AutomatePS/AutomatePS