Skip to main content

ensure_sql_server_agent_running

Function ensure_sql_server_agent_running 

Source
pub async fn ensure_sql_server_agent_running(
    client: &mut Client,
) -> Result<(), SqlServerError>
Expand description

Ensure the SQL Server Agent is running.

Azure SQL Database has no SQL Server Agent (CDC is driven by an internal scheduler and sys.dm_server_services is unavailable), so the check is skipped for that edition.

See: https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-server-services-transact-sql?view=azuresqldb-current&viewFallbackFrom=sql-server-ver17