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 (9)
| Label | Occurrences |
|---|---|
| SQL Server Agent canonical | 10 |
| SQL Server Agent jobs | 10 |
| Microsoft SQL Server Agent | 1 |
| Microsoft SQL Server Agent feature | 1 |
| SQL Server Agent alerts | 1 |
| SQL Server Agent operators | 1 |
| SQL Server Agent proxies | 1 |
| SQL Server Agent schedules | 1 |
| SQL Server Agent subsystem | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T2555707 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: SQL Server Agent Context triple: [Database Mail, usesService, SQL Server Agent]
-
A.
SQL Server
SQL Server is Microsoft's enterprise-grade relational database management system used for storing, managing, and analyzing data in a wide range of applications.
-
B.
SQL Server Integration Services
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
-
C.
SQL Server Management Studio
SQL Server Management Studio is a graphical administration and development environment used to configure, manage, and query Microsoft SQL Server databases.
-
D.
SQL Server Profiler
SQL Server Profiler is a graphical tool for monitoring, tracing, and analyzing SQL Server database engine events in real time to help with performance tuning and troubleshooting.
-
E.
SQL Server Reporting Services
SQL Server Reporting Services is a server-based platform from Microsoft for designing, managing, and delivering paginated and interactive reports from relational and multidimensional data sources.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: SQL Server Agent Target entity description: SQL Server Agent is a Microsoft SQL Server component that automates administrative tasks such as job scheduling, alerting, and routine maintenance operations.
-
A.
SQL Server
SQL Server is Microsoft's enterprise-grade relational database management system used for storing, managing, and analyzing data in a wide range of applications.
-
B.
SQL Server Integration Services
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
-
C.
SQL Server Management Studio
SQL Server Management Studio is a graphical administration and development environment used to configure, manage, and query Microsoft SQL Server databases.
-
D.
SQL Server Profiler
SQL Server Profiler is a graphical tool for monitoring, tracing, and analyzing SQL Server database engine events in real time to help with performance tuning and troubleshooting.
-
E.
SQL Server Reporting Services
SQL Server Reporting Services is a server-based platform from Microsoft for designing, managing, and delivering paginated and interactive reports from relational and multidimensional data sources.
- F. None of above. chosen
Statements (50)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server component
ⓘ
job scheduling service ⓘ |
| canBeManagedWith |
SQL Server Management Objects (SMO)
ⓘ
Transact-SQL ⓘ
linked to:
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 |
Microsoft SQL Server
ⓘ
linked to:
SQL Server
|
| requires |
SQL Server Database Engine
ⓘ
linked to:
SQL Server
|
| 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
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: SQL Server Agent Description of subject: SQL Server Agent is a Microsoft SQL Server component that automates administrative tasks such as job scheduling, alerting, and routine maintenance operations.
Referenced by (27)
Full triples — surface form annotated when it differs from this entity's canonical label.
subject linked to:
Standard Edition
linked to: SQL Server Agent
linked to: SQL Server Agent
linked to: SQL Server Agent
linked to: SQL Server Agent
linked to: SQL Server Agent
linked to: SQL Server Agent
linked to: SQL Server Agent
linked to: SQL Server Agent
linked to: SQL Server Agent
linked to: SQL Server Agent
linked to: SQL Server Agent
subject linked to:
SQL Server Management Objects (SMO)
linked to: SQL Server Agent
linked to: SQL Server Agent
linked to: SQL Server Agent
linked to: SQL Server Agent