dbo.systaskids (Transact-SQL)


Updated: August 9, 2016

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 nameData typeDescription
task_idintID of the task
job_iduniqueidentifierID of the job to which the task is mapped

Community Additions