SQL Server Agent Starting and Stopping

SQLAgentStart.sql

--######## FOR STARTING WHEN STOPPED OR STOPPING ####################
--IF YOU NEED TO STOP THE SERVER FIRST TO TRUN THE LINE BELOW
--EXEC xp_servicecontrol N'STOP',N'SQLServerAGENT';
USE master;
GO

CREATE TABLE #SQLAgentStatus
(
Status varchar(50),
Timestamp datetime default (getdate())
);
GO

INSERT #SQLAgentStatus (Status)
EXEC xp_servicecontrol N'QUERYSTATE',N'SQLServerAGENT';
GO

DECLARE @LatestStatus VARCHAR(50) 
SET @LatestStatus = (SELECT Status FROM #SqlAgentStatus WHERE timestamp = (SELECT MAX(timestamp) FROM #SqlAgentStatus))

IF ('Stopped.' = @LatestStatus OR 'Stopping...' = @LatestStatus)
BEGIN
	-- START SQL Server Agent
	EXEC xp_servicecontrol N'START',N'SQLServerAGENT';
	
	INSERT #SQLAgentStatus (Status)
	EXEC xp_servicecontrol N'QUERYSTATE',N'SQLServerAGENT';

END
GO

EXEC xp_servicecontrol N'QUERYSTATE',N'SQLServerAGENT' 
GO

SELECT * FROM #SQLAgentStatus
GO

DROP TABLE #SQLAgentStatus
GO

SqlAgentStop.sql

--######## FOR STOPPING WHEN STARTED OR STARTING ####################
--IF YOU NEED TO START THE SERVER FIRST TO TRUN THE LINE BELOW
--EXEC xp_servicecontrol N'START',N'SQLServerAGENT';

USE master;
GO

CREATE TABLE #SQLAgentStatus
(
Status varchar(50),
Timestamp datetime default (getdate())
);
GO

INSERT #SQLAgentStatus (Status)
EXEC xp_servicecontrol N'QUERYSTATE',N'SQLServerAGENT';
GO

DECLARE @LatestStatus VARCHAR(50) 
SET @LatestStatus = (SELECT Status FROM #SqlAgentStatus WHERE timestamp = (SELECT MAX(timestamp) FROM #SqlAgentStatus))

IF ('Running.' = @LatestStatus OR 'Starting...' = @LatestStatus)
BEGIN
	-- START SQL Server Agent
	EXEC xp_servicecontrol N'STOP',N'SQLServerAGENT';
	
	INSERT #SQLAgentStatus (Status)
	EXEC xp_servicecontrol N'QUERYSTATE',N'SQLServerAGENT';

END
GO

DROP TABLE #SQLAgentStatus
GO

Two simple scripts that starts the sql server agent if stopped and similarly, stops the sql server agent if started

great scripts. i used them together, first stop then start, since those two actions got executed almost in the same time. so the agent may still be stopping, the start would start it, thus causing "1056, 'An instance of the service is already running.'". so it would be nice to mention a possible wait between the two:
WAITFOR DELAY '00:00:05'
GO