background_services

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
name	VARCHAR	31			null

|

| | | title | VARCHAR | 127 | | | null |

|

|

name for reports

| | active | BOOLEAN | 3 | | | 0 |

|

| | | running | BOOLEAN | 3 | | | -1 |

|

|

True indicates managed service is busy. Skip this interval

| | next_run | TIMESTAMP | 19 | | | current_timestamp() |

|

| | | execute_interval | INT | 10 | | | 0 |

|

|

minimum number of minutes between function calls,0=manual mode

| | function | VARCHAR | 127 | | | null |

|

|

name of background service function

| | require_once | VARCHAR | 255 | √ | | NULL |

|

|

include file (if necessary)

| | sort_order | INT | 10 | | | 100 |

|

|

lower numbers will be run first

|

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	name

Relationships

Close relationships within degrees of separation