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: 0

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 IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3User ID Searchuniqueidentifier
4User Name Searchnvarchar(100)
5User Language ID Searchint
6User Format ID Searchint
7User Time Zone Searchnvarchar(64)
8User App ID Searchnvarchar(40)
9Company Searchnvarchar(60)
10Is Ready Searchtinyint
11Not Before Searchdatetime
12Run Codeunit Searchint
13Failure Codeunit Searchint
14Record Searchvarbinary(448)
15Timeout Searchbigint
16Tenant ID Searchnvarchar(256)
17Last Error Searchimage
18$systemId Searchuniqueidentifier
19$systemCreatedAt Searchdatetime
20$systemCreatedBy Searchuniqueidentifier
21$systemModifiedAt Searchdatetime
22$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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