Scheduled Task – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables SScheduled Task

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000175

Table Type: System

Table Name: Scheduled Task
Database Table Name: Scheduled Task

Table Number: 2000000175

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Scheduled Task can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [Scheduled Task]

Show/hide an example select of all columns by name

SELECT

   [ID]
   ,[User ID]
   ,[User Name]
   ,[User Language ID]
   ,[User Format ID]
   ,[User Time Zone]
   ,[User App ID]
   ,[Company]
   ,[Is Ready]
   ,[Not Before]
   ,[Run Codeunit]
   ,[Failure Codeunit]
   ,[Record]
   ,[Timeout]
   ,[Tenant ID]
   ,[Last Error]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [Scheduled Task]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [Scheduled Task] AS [Scheduled Task]
LEFT JOIN
   [Company] AS [Company]
      ON
         [Scheduled Task].[Company] = [Company].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Scheduled Task].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Scheduled Task].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Scheduled Task table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	ID	ID	Normal	GUID	16	ID	uniqueidentifier
2	User ID	User ID	Normal	GUID	16	User ID	uniqueidentifier
3	User Name	User Name	Normal	Text	50	User Name	nvarchar(100)
4	User Language ID	User Language ID	Normal	Integer	4	User Language ID	int
5	User Format ID	User Format ID	Normal	Integer	4	User Format ID	int
6	User Time Zone	User Time Zone	Normal	Text	32	User Time Zone	nvarchar(64)
7	User App ID	User App ID	Normal	Text	20	User App ID	nvarchar(40)
10	Company	Company	Normal	Text	30	Company	nvarchar(60)
	Key to join to the Company table. Show/hide example query SELECT [Scheduled Task].[Company] ,[Company].[Name] FROM [Scheduled Task] AS [Scheduled Task] LEFT JOIN [Company] AS [Company] ON [Scheduled Task].[Company] = [Company].[Name]
11	Is Ready	Is Ready	Normal	Boolean	4	Is Ready	tinyint
12	Not Before	Not Before	Normal	DateTime	8	Not Before	datetime
20	Run Codeunit	Run Codeunit	Normal	Integer	4	Run Codeunit	int
21	Failure Codeunit	Failure Codeunit	Normal	Integer	4	Failure Codeunit	int
22	Record	Record	Normal	RecordID	448	Record	varbinary(448)
23	Timeout	Timeout	Normal	Duration	8	Timeout	bigint
24	Tenant ID	Tenant ID	Normal	Text	128	Tenant ID	nvarchar(256)
25	Last Error	Last Error	Normal	BLOB	8	Last Error	image
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Scheduled Task].[$systemCreatedBy] ,[User].[User Security ID] FROM [Scheduled Task] AS [Scheduled Task] LEFT JOIN [User] AS [User] ON [Scheduled Task].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier