Executive Object Properties Methods Lists Collections
| Property | Description |
|---|
| AlertSystem AlertSystem Write: No |
The AlertSystem object. |
| Application Application Write: No |
The Application object. |
| AutoStart Boolean Write: Yes |
Determines if the Executive service starts automatically when Windows NT starts. If True, the Executive starts when Windows NT starts. If False, the Executive must be started manually. |
| LimitHistoryRows Boolean Write: Yes |
Determines if old task history rows (in the syshistory table) are overwritten with new ones. If True, the LimitHistoryRowsMax property limits the number of rows. If False, there is no limit to the number of rows. |
| LimitHistoryRowsMax Long Write: Yes |
The maximum number of task history rows (in the syshistory table) to keep. When this number is exceeded, old task history rows are purged to make room for new ones. |
| Parent SQLServer Write: No |
The SQLServer object. |
| RestartSQLServer Boolean Write: Yes |
Determines if the Exective service will automatically restart SQL Server. If True, the Executive will restart SQL Server when it detects that SQL Server has stopped unexpectedly. If False, the Executive will not attempt to restart SQL Server. |
| RestartSQLServerInterval Long Write: Yes |
The time in minutes between checks made by the Executive to confirm that SQL Server is still running. Valid values are 1 through 60. This property is only used when RestartSQLServer is True. |
| Status SQLOLE_SVCSTATUS_TYPE Write: No |
Service status. |
| TypeOf SQLOLE_OBJECT_TYPE Write: No |
The type of object. |
| UserData Long Write: Yes |
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property. |