Description of FUDforum table fud30_jobs. This table was introduced with FUDforum 3.0.2 to schedule common tasks like importing E-mail messages, Usenet posts, XML Feeds, etc. For details, see Job Manager.
| Column Name | Datatype | Can be Null? | Key? | Default | Description |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | |
| name | varchar(32) | NO | Task name. | ||
| start_minute | varchar(32) | NO | * | Minute. | |
| start_hour | varchar(32) | NO | * | Hour. | |
| start_dom | varchar(32) | NO | * | Day of week. | |
| start_month | varchar(32) | NO | * | Month. | |
| start_dow | varchar(32) | NO | * | Day of week. | |
| cmd | varchar(32) | NO | Command to run. | ||
| nextrun | bigint(20) | NO | 0 | ||
| lastrun | bigint(20) | NO | 0 | ||
| locked | bigint(20) | NO | 0 | Currently running? | |
| job_opt | int(11) | NO | 0 | Job options. See below. |
| Index Name | Uniqueness | Column Name | Seq in index | Comments |
|---|---|---|---|---|
| PRIMARY | UNIQUE | id | 1 |
Binary values for job_opt: