schedule table

schedule Table (379)

Generic scheduled tasked handling time scheduling, locking and error messages

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

Fields	Types	Description
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