The IN_DB_UTIL_SP_CHECK_TIME stored procedure is used to determine if the MAX_TIME session parameter has elapsed for the specified identifier.
This only applies if the MAX_MINUTES session parameter has been set to a value greater than zero when the IN_DB_UTIL_SP_SESSION_SET_ATTRIBUTES procedure is called by the IN_DB_UTIL_SP_SESSION_SETUP procedure when initializing a session within the IN_DB_UTIL framework.
This procedure, in conjunction with MAX_MINUTES, should not be used in conjunction with downtime events as it could lead to incomplete operations.
| Parameter | Description | |
|---|---|---|
| IDENTIFIER | Type: | INPUT |
| Datatype: | SYSNAME | |
| Default Value: | NULL | |
| Description | Specifies the identifier for which to display the session attributes. | |
| Options |
IN_DB_UTIL SYNC UPGRADE |
|
| DEBUG | Type: | INPUT |
| Datatype: | NVARCHAR(3) | |
| Default Value: | NO | |
| Description | Specifies whether to display the timestamps used when checking if MAX_TIME has elapsed. | |
| Options |
YES = Displays the current and maximum timestamps. NO = No additional information is displayed. |
|
| V_RESULTS | Type: | OUTPUT |
| Datatype: | SMALLINT | |
| Default Value: | 0 | |
| Description | Specifies if the MAX_TIME session parameter has elapsed or not. 0 = MAX_TIME has not
yet elapsed or is undefined 1 = MAX_TIME has elapsed. 0 = MAX_TIME has not yet elapsed or is undefined 1 = MAX_TIME has elapsed. |
|
Examples
DECLARE @V_CHECK_TIME SMALLINT; EXEC @V_CHECK_TIME = IN_CHECK_TIME @IDENTIFIER = 'IN_DB_UTIL', @DEBUG = 'YES' PRINT CASE @V_CHECK_TIME WHEN 0 THEN 'MAX_TIME has not elapsed' WHEN 1 THEN 'MAX_TIME has elapsed' END;