Support

Windows Scheduled Task

 

dbOmnibus capture and alerts can be ran using Windows Task Scheduler instead of SQL Agent jobs if desired.

This is the preferred method for SQL Server Express, since Express does not have SQL Agent.

Execution of the stored procedures can be scheduled by using cmd files and Windows Scheduled Tasks. Follow these steps.

  1. Execute the Deployment script. This script creates and updates the objects that are needed
  2. Create cmd files to execute the stored procedures; for example:
    sqlcmd -E -S .\SQLEXPRESS -d master -Q "EXECUTE dbo.sp_RunCaptures
  3. In Windows Scheduled Tasks, create a task to call the cmd file
  4. Schedule the task
  5. Start the task and verify that it is completing successfully
Page Last Updated: 26 June 2025