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
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
[timestamp]
,[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 columns in Scheduled Task table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | ID  | uniqueidentifier |
| 3 | User ID | uniqueidentifier |
| 4 | User Name | nvarchar(100) |
| 5 | User Language ID | int |
| 6 | User Format ID | int |
| 7 | User Time Zone | nvarchar(64) |
| 8 | User App ID | nvarchar(40) |
| 9 | Company | nvarchar(60) |
| 10 | Is Ready | tinyint |
| 11 | Not Before | datetime |
| 12 | Run Codeunit | int |
| 13 | Failure Codeunit | int |
| 14 | Record | varbinary(448) |
| 15 | Timeout | bigint |
| 16 | Tenant ID | nvarchar(256) |
| 17 | Last Error | image |
| 18 | $systemId | uniqueidentifier |
| 19 | $systemCreatedAt | datetime |
| 20 | $systemCreatedBy | uniqueidentifier |
| 21 | $systemModifiedAt | datetime |
| 22 | $systemModifiedBy | uniqueidentifier |