RELATIONSHIPS

device_skips( $backend?, $max_deferrals?, $retry_after? )

Returns the set of device_skip entries which apply to this job. They match the device IP, current backend, and job action.

You probably want to use the ResultSet method skipped which completes this query with a backend host, max_deferrals, and retry_after parameters (or sensible defaults).

target

Returns the single device to which this Job entry was associated.

The JOIN is of type LEFT, in case the device is not in the database.

METHODS

display_name

An attempt to make a meaningful statement about the job.

ADDITIONAL COLUMNS

entered_stamp

Formatted version of the entered field, accurate to the minute.

The format is somewhat like ISO 8601 or RFC3339 but without the middle T between the date stamp and time stamp. That is:

2012-02-06 12:49

started_stamp

Formatted version of the started field, accurate to the minute.

The format is somewhat like ISO 8601 or RFC3339 but without the middle T between the date stamp and time stamp. That is:

2012-02-06 12:49

finished_stamp

Formatted version of the finished field, accurate to the minute.

The format is somewhat like ISO 8601 or RFC3339 but without the middle T between the date stamp and time stamp. That is:

2012-02-06 12:49

duration

Difference between started and finished.