Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
Job Id |
|||
| domain_id | INT UNSIGNED | 10 | null |
|
|
Which Domain is this scheduled job for |
||||
| run_frequency | VARCHAR | 8 | √ | Daily |
|
|
Scheduled job run frequency. |
|||
| last_run | TIMESTAMP | 19 | √ | null |
|
|
When was this cron entry last run |
|||
| scheduled_run_date | TIMESTAMP | 19 | √ | null |
|
|
When is this cron entry scheduled to run |
|||
| name | VARCHAR | 255 | √ | null |
|
|
Title of the job |
|||
| description | VARCHAR | 255 | √ | null |
|
|
Description of the job |
|||
| api_entity | VARCHAR | 255 | √ | null |
|
|
Entity of the job api call |
|||
| api_action | VARCHAR | 255 | √ | null |
|
|
Action of the job api call |
|||
| parameters | TEXT | 65535 | √ | null |
|
|
List of parameters to the command. |
|||
| is_active | TINYINT | 3 | √ | null |
|
|
Is this job active? |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_job_domain_id | Performance | Asc | domain_id |
Relationships
Close relationships within degrees of separation
