Scheduled 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1ID Primary Key SearchIDNormalGUID16IDuniqueidentifier
2User ID SearchUser IDNormalGUID16User IDuniqueidentifier
3User Name SearchUser NameNormalText50User Namenvarchar(100)
4User Language ID SearchUser Language IDNormalInteger4User Language IDint
5User Format ID SearchUser Format IDNormalInteger4User Format IDint
6User Time Zone SearchUser Time ZoneNormalText32User Time Zonenvarchar(64)
7User App ID SearchUser App IDNormalText20User App IDnvarchar(40)
10Company SearchCompanyNormalText30Companynvarchar(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]
11Is Ready SearchIs ReadyNormalBoolean4Is Readytinyint
12Not Before SearchNot BeforeNormalDateTime8Not Beforedatetime
20Run Codeunit SearchRun CodeunitNormalInteger4Run Codeunitint
21Failure Codeunit SearchFailure CodeunitNormalInteger4Failure Codeunitint
22Record SearchRecordNormalRecordID448Recordvarbinary(448)
23Timeout SearchTimeoutNormalDuration8Timeoutbigint
24Tenant ID SearchTenant IDNormalText128Tenant IDnvarchar(256)
25Last Error SearchLast ErrorNormalBLOB8Last Errorimage
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Scheduled Task].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [Scheduled Task] AS [Scheduled Task]
LEFT JOIN
       [User] AS [User]
              ON
                     [Scheduled Task].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

Your email address will not be published. Required fields are marked *