dbo.systaskids (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains a mapping of tasks created in earlier versions of SQL Server to SQL Server Management Studio jobs in the current version. This table is stored in the msdb database.

Column name Data type Description
task_id int ID of the task
job_id uniqueidentifier ID of the job to which the task is mapped