SQL Server Agent başlatma


To see the state of “Agent XPs” option, run the folowing code:

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Agent XPs'

Agent_xps_disabled_sp_configure

To enable the SQL Server Agent extended stored procedures:

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Agent XPs', 1
GO
RECONFIGURE
GO

Agent_xps_enable_sp_configure

The setting takes effect without a server restart.

To see the state of “Agent XPs” option again:

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Agent XPs'

Agent_xps_enabled_sp_configure

Refresh Management Studio Object Explorer…

Agent_xps_refresh_object_explorer

No comment

Bir cevap yazın

E-posta hesabınız yayımlanmayacak.