SQL Server’da Agent Durumunu Kontrol Eden Prosedür
Herkese merhaba, Bu kısımda SQL Server’da agent durumunu kontrol eden prosedür kodları olacak. IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME =’KDT_SP_SYSTEM_HEATH_SQL_CHECK_SQL_AGENT’) BEGIN DROP PROCEDURE KDT_SP_SYSTEM_HEATH_SQL_CHECK_SQL_AGENT END GO CREATE PROCEDURE [dbo].[KDT_SP_SYSTEM_HEATH_SQL_CHECK_SQL_AGENT] AS BEGIN /* created by KRAAI Du Toit TO CHECK IF SQL AGENT IS RUNNING EG EXEC [KDT_SP_SYSTEM_HEATH_SQL_CHECK_SQL_AGENT] used in...