Execute the following Microsoft SQL Server T-SQL script to demonstrate the use of minimal control over SQL Agent:

USE AdventureWorks

GO

CREATE TABLE SQLAgentStatus

( Status varchar(50),

  Timestamp smalldatetime default (getdate())

)

GO

-- Check status

INSERT SQLAgentStatus (Status)

EXEC xp_servicecontrol N'QUERYSTATE',N'SQLServerAGENT'

GO

SELECT * FROM SQLAgentStatus

GO

-- STOP SQL Server Agent

EXEC xp_servicecontrol N'STOP',N'SQLServerAGENT'

GO

-- START SQL Server Agent

EXEC xp_servicecontrol N'START',N'SQLServerAGENT'

GO