如何用SQL语句获知SQL Agent服务是否启动

/*
**取得某项服务是否启动

HOME
haoK.Y

**2004-10-20
根据 net start返回的结果判断某项服务是否启动

**示例
DECLARE @IsOnWorking BIT
EXEC spServiceIsOnWorking 'MSSQL$NEWINSTANCE', @IsOnWorking OUTPUT
SELECT @IsOnWorking

*/
CREATE PROCEDURE spServiceIsOnWorking
(
        @ServiceName        VARCHAR(100),
        @IsOnWorking        BIT OUTPUT
)
AS
SET NOCOUNT ON

CREATE TABLE #Output
(
        OT VARCHAR(100)
)

INSERT INTO #Output
EXEC master..xp_cmdshell 'net start'

SET @IsOnWorking = 
        CASE
                WHEN EXISTS (
                        SELECT TOP 1 1
                        FROM #Output
                        WHERE OT LIKE '%' + @ServiceName + '%'
                ) THEN 1
                ELSE 0
        END

DROP TABLE #Output

SET NOCOUNT OFF
GO

本文转自 http://www.itpub.net/thread-278460-1-1.html