systaskids (Transact-SQL)

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