|
gptkbp:instanceOf
|
SQL Server feature
|
|
gptkbp:auditedBy
|
true
|
|
gptkbp:broadcastOn
|
true
|
|
gptkbp:canBe
|
gptkb:SQL_Server_Management_Studio
gptkb:Transact-SQL
SQL Server Agent service account
proxy account
|
|
gptkbp:canBeCategorizedBy
|
job category
|
|
gptkbp:canBeCopiedBy
|
true
|
|
gptkbp:canBeDisabled
|
true
|
|
gptkbp:canBeLogged
|
true
|
|
gptkbp:canBeModified
|
true
|
|
gptkbp:canBeNotifiedOnCompletion
|
true
|
|
gptkbp:canBeNotifiedOnFailure
|
true
|
|
gptkbp:canBeNotifiedOnSuccess
|
true
|
|
gptkbp:canBePossessedBy
|
gptkb:SQLAgentOperatorRole
gptkb:SQLAgentReaderRole
gptkb:SQLAgentUserRole
gptkb:SQL_Server_login
sysadmin role
SQL Server role
|
|
gptkbp:canBeRunManually
|
true
|
|
gptkbp:canBeScheduledBy
|
SQL Server Agent scheduler
|
|
gptkbp:canBeScripted
|
true
|
|
gptkbp:canBeStarted
|
true
|
|
gptkbp:canBeStopped
|
true
|
|
gptkbp:canCreate
|
SQL Server login with appropriate permissions
sysadmin
|
|
gptkbp:canImport
|
true
|
|
gptkbp:component
|
operators
alerts
schedules
job steps
|
|
gptkbp:exportedTo
|
true
|
|
https://www.w3.org/2000/01/rdf-schema#label
|
SQL Server Agent jobs
|
|
gptkbp:monitors
|
gptkb:Windows_Event_Log
SQL Server Agent logs
SQL Server Error Log
|
|
gptkbp:partOf
|
gptkb:SQL_Server_Agent
|
|
gptkbp:removes
|
true
|
|
gptkbp:storage
|
gptkb:msdb_database
|
|
gptkbp:triggeredBy
|
alerts
schedules
manual execution
|
|
gptkbp:usedFor
|
automating administrative tasks
backing up databases
executing SSIS packages
running T-SQL scripts
running maintenance plans
scheduling database tasks
sending alerts
|
|
gptkbp:bfsParent
|
gptkb:MSDB_database
|
|
gptkbp:bfsLayer
|
7
|