Statements (61)
| Predicate | Object |
|---|---|
| gptkbp:instance_of |
gptkb:Data
|
| gptkbp:can |
Recurring jobs
Job history Windows Event Log |
| gptkbp:can_be_configured_for |
Job notifications
Proxy accounts Job retries Job step execution |
| gptkbp:can_be_scheduled_to |
Run at specific times
|
| gptkbp:can_be_used_to |
Run maintenance plans
Schedule cleanup tasks Schedule index maintenance tasks Automate ETL processes Automate data loading tasks Automate database tasks Automate performance tuning tasks Execute scripts on a schedule Manage SQL Server jobs across instances Manage alerts and notifications Manage job schedules and dependencies Monitor job execution status Perform data archiving Run data transformation tasks Schedule backups and restores Schedule data synchronization tasks Schedule database integrity checks Schedule report generation |
| gptkbp:can_handle |
Error handling
|
| gptkbp:can_perform |
Stored procedures
Batch files External programs Database maintenance tasks CLR stored procedures Transact-SQL scripts |
| gptkbp:control_system |
gptkb:SQL_Server_Management_Studio
|
| gptkbp:controls |
gptkb:SQL_Server_Reporting_Services_(SSRS)
gptkb:SQL_Server_Integration_Services_(SSIS) gptkb:SQL_Server_Analysis_Services_(SSAS) Alerts Database backups Replication tasks |
| https://www.w3.org/2000/01/rdf-schema#label |
SQL Server Agent
|
| gptkbp:integrates_with |
gptkb:Windows_Task_Scheduler
|
| gptkbp:is_monitored_by |
gptkb:SQL_Server_Profiler
|
| gptkbp:is_used_for |
Data import/export
|
| gptkbp:monitors |
SQL Server performance
|
| gptkbp:part_of |
gptkb:Microsoft_SQL_Server
|
| gptkbp:provides |
Job scheduling
|
| gptkbp:receives |
Email notifications
Alerts via SQL Mail |
| gptkbp:requires |
gptkb:SQL_Server_Database_Engine
|
| gptkbp:runs_through |
SSIS packages
Power Shell scripts |
| gptkbp:security |
Role-based security
|
| gptkbp:supports |
Automated tasks
|
| gptkbp:trigger_type |
Jobs based on events
|
| gptkbp:uses |
SQL Server jobs
|
| gptkbp:bfsParent |
gptkb:My_SQL
gptkb:SQL_Server_Management_Studio gptkb:Microsoft_SQL_Server |
| gptkbp:bfsLayer |
4
|