sp_CaptureStartup
Capture instance startup events into the [Events] table.
sp_CaptureStartup is a utility procedure. There is no reason for this to be executed manually.
It is called by a SQL Agent job (dbOmnibus Startup) when the instance starts.
It will cause a Alert 2008 Health Finding notification to be sent.
Usage:
sp_CaptureStartup
Capture the started date the the [Vitals] table and send a Health Finding notification.
sp_CaptureStartup 'Vitals'
Capture the started date the the [Vitals] table, do not send a Health Finding notification.
Technical Details:
- Type: Utility
- Schema: dbo
- Parameters:
- @Mode (optional) string
- Recommended cadence: Instance Startup
Related objects
Page Last Updated: 21 September 2025