How to set the polling interval (Service Manager)
SQL Server 2000
To set the polling interval
- Start SQL Server Service Manager, if it is not already running.
- In the Microsoft® Windows® taskbar, right-click SQL Server Service Manager, and then click Options.
- In the Polling interval (seconds) box, enter a polling interval.
The polling interval determines how often SQL Server Service Manager checks the state of Microsoft SQL Server™, SQL Server Agent, and Microsoft Distributed Transaction Coordinator (MS DTC).
- Optionally, select the Verify service control action check box if you want SQL Server Service Manager to provide a confirmation box before stopping, pausing, starting, or continuing a service, including dependent services such as SQL Server Agent.