Transact-SQL Reference
systaskids
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 |