biuan SAP® BUSINESS ONE SDK
SQL Others / Schedules
API TSCD
TSCD - Schedules Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SrvcName KEY UNIQUEService application namenVarChar
20
NAME_SCHEDYes
SchedTypeType of scheduleVarChar
P) Suspended / Paused
O) Once
S) Every X seconds
M) Every X minutes
D) Daily
W) Weekly
T) Monthly
1
P
SchedDateScheduled dateDate
8
SchedDayScheduled daynVarChar
2
1
IntervalIntervalInt
11
LastExDateLast execution dateDate
8
AutoStartAuto run when OS startsVarChar
Y) Yes
N) NO
1
Y

SELECT statement

SELECT TSCD.SrvcName AS 'Service application name', TSCD.SchedType AS 'Type of schedule', TSCD.SchedDate AS 'Scheduled date', TSCD.SchedDay AS 'Scheduled day', TSCD.Interval AS 'Interval', TSCD.LastExDate AS 'Last execution date', TSCD.AutoStart AS 'Auto run when OS starts' FROM TSCD AS TSCD

Related information
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates