Enable Agent XPS using T SQL

EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

EXEC SP_CONFIGURE 'Agent XPs', 1;
GO
RECONFIGURE;
GO