Jaa


CountResetTime Property (SQL-DMO)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The CountResetTime property represents the time at which the SQL Server Agent alert occurrence count was reset to 0.

Syntax

object
.CountResetTime 

Parts

  • object
    An expression that evaluates to an object in the Applies To list

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetCountResetTime(LPLONG pRetVal);

Note

SQL Distributed Management Objects (SQL-DMO) uses a scaled long integer to represent a time. The integer is built as a sum of the hour scaled by 10000, the minute scaled by 100, and the seconds. The time value uses a 24-hour clock. For example, the time 13:03:09 is represented by the long integer value 130309.

Remarks

The CountResetTime property is implemented for C/C++ applications only. The value represents the time portion of a date and time value. The date portion of the value is represented by the CountResetDate property.

Applies To:

Alert Object