SQL Server Agent

GPTKB entity

Statements (53)
Predicate Object
gptkbp:instanceOf gptkb:software
gptkbp:accessibleBy gptkb:SQL_Server_Management_Studio
gptkb:PowerShell
gptkb:Transact-SQL
gptkb:SQL_Server_Agent_API
gptkbp:availableOn gptkb:SQL_Server_Enterprise_Edition
gptkb:SQL_Server_Standard_Edition
gptkbp:canAutomate gptkb:PowerShell
gptkb:Transact-SQL
gptkbp:canBe gptkb:SQLAgentOperatorRole
gptkb:SQLAgentReaderRole
gptkb:SQLAgentUserRole
SQL Server roles
as Windows service
gptkbp:canBeDisabled true
gptkbp:canBeRestarted true
gptkbp:compatibleWith gptkb:SQL_Server_Express_Edition
gptkb:SQL_Server_Web_Edition
gptkbp:configuration gptkb:SQL_Server_Management_Studio
gptkbp:defaultPort nan
gptkbp:developedBy gptkb:Microsoft
gptkbp:documentation https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent
gptkbp:firstReleased 1995
gptkbp:function automation
alerting
job scheduling
gptkbp:hasComponent gptkb:Jobs
Alerts
Schedules
Operators
https://www.w3.org/2000/01/rdf-schema#label SQL Server Agent
gptkbp:jobHistoryStoredIn gptkb:msdb_database
gptkbp:license proprietary
gptkbp:monitors gptkb:SQL_Server_Management_Studio
gptkb:SQL_Server_Profiler
gptkbp:operatingSystem gptkb:Windows
gptkbp:partOf gptkb:Microsoft_SQL_Server
gptkbp:relatedTo gptkb:SQL_Server_Integration_Services
gptkb:SQL_Server_Reporting_Services
gptkb:SQL_Server_Database_Engine
gptkbp:requires gptkb:SQL_Server_authentication
Windows authentication
gptkbp:service gptkb:SQLSERVERAGENT
gptkbp:storesJobsIn gptkb:msdb_database
gptkbp:supports Operating system (CmdExec) jobs
Replication jobs
SSIS package jobs
T-SQL jobs
gptkbp:transmittedBy email notifications
net send notifications
pager notifications
gptkbp:bfsParent gptkb:SQL_Server_Management_Studio
gptkbp:bfsLayer 6