systaskids System Table - SQL Server 2000
Contains a mapping of tasks created in earlier versions of Microsoft® SQL Server™ to SQL Server Enterprise Manager 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