schedule Table (379)

•

Environment: onsite, online

• 2 minutes to read

Generic scheduled tasked handling time scheduling, locking and error messages

Fields

Name	Description	Type	Null
id	Primary key	PK
domain	Type of scheduled task	domain	●
status	Schedules current status	status	●
frequency	Type of schedule algorithm to use	frequency	●
asap	Run schedule ASAP	Bool
disabled	Disable the schedule	Bool
stop	Signal to stop schedule	Bool
name	Name of the schedule	String(255)	●
after_schedule_id	Run after another schedule have completed	FK schedule	●
minute_interval	Interval in minutes, used by Minutely	Int	●
weekdays	Bitfield: which days of the week to run	Int	●
months	Bitfield: which months of the year to run	Int	●
min_of_hour	Run at a given minute in an hour	Int	●
day_of_month	What day of month to run	Int	●
time_of_day	Time of day to execute if not specified.	DateTime	●
once_at	Execute once at	DateTime	●
next_execution	Next execution	DateTime	●
last_execution	Last execution	DateTime	●
execution_time	Amount of time in seconds used by last execution	Int	●
lock_expire	Lock preventing the same schedule to run simultaniously	DateTime	●
lock_pid	PID preventing the same schedule to run simultaniously	Int	●
lock_ttl	Lock time to live	Int	●
error_message	Last error message	Clob	●
last_error	Time of last error	DateTime	●
retries	Number of retries since last successfull execution	Int
retry_interval	Number of minutes between each retry	Int	●

schedule table relationship diagram

Fields	Types	Description
id	PK	Clustered, Unique
after_schedule_id	FK	Index

Table	Description
dbi_agent_schedule	DBI agent schedule settings
schedule	Generic scheduled tasked handling time scheduling, locking and error messages
scheduled_task	A scheduled entry executing a script at certain times