SQL Server Agent

E277001

SQL Server Agent is a Microsoft SQL Server component that automates administrative tasks such as job scheduling, alerting, and routine maintenance operations.

All labels observed (4)

Label Occurrences
SQL Server Agent canonical 8
SQL Server Agent alerts 1
SQL Server Agent jobs 1

How this entity was disambiguated

Statements (50)

Predicate Object
instanceOf SQL Server component
job scheduling service
canBeManagedWith SQL Server Management Objects (SMO)
SQL
surface form: Transact-SQL
canSendNotificationsVia email
net send (deprecated)
pager
configurationStoredIn msdb system database
developer Microsoft
exposesInterface SQL Server Management Studio
hasFeature SQL Server Agent tokens
alert responses
alerts
error log
fail-safe operator
job categories
job history logging
multi-server job management
notifications
operators
proxies
schedules
hasFixedDatabaseRole SQLAgentOperatorRole
SQLAgentReaderRole
SQLAgentUserRole
isDisabledByDefaultIn some SQL Server Express editions
jobHistoryStoredIn msdb system database
partOf SQL Server
surface form: Microsoft SQL Server
requires SQL Server
surface form: SQL Server Database Engine
runsAs Windows service
storesMetadataIn msdb system database
supports Operating system (CmdExec) job steps
PowerShell job steps
Replication agent jobs
SQL Server Analysis Services command job steps
SQL Server Integration Services (SSIS) package job steps
T-SQL job steps
alerting
automation of administrative tasks
backup jobs
database integrity check jobs
index maintenance jobs
job scheduling
routine maintenance operations
supportsAlertOn SQL Server error numbers
SQL Server performance conditions
WMI events
uses SQL Server Agent fixed database roles
SQL Server logins
SQL Server roles

How these facts were elicited

Referenced by (11)

Full triples — surface form annotated when it differs from this entity's canonical label.

Database Mail usesService SQL Server Agent
Policy-Based Management integratesWith SQL Server Agent
Management Data Warehouse uses SQL Server Agent
Standard Edition providesFeature SQL Server Agent
subject surface form: Microsoft SQL Server Standard Edition
Azure SQL Managed Instance supports SQL Server Agent
SQL Mail associatedWith SQL Server Agent
this entity surface form: SQL Server Agent alerts
SQL Mail associatedWith SQL Server Agent
this entity surface form: SQL Server Agent operators
SQL Mail usedBy SQL Server Agent
this entity surface form: SQL Server Agent jobs
Object Explorer providesViewOf SQL Server Agent