nightly_job table - SuperOffice

nightly_job Table (511)

Lock and scheduling status for NetServer nightly jobs; one row per job, ensuring only one server at a time runs a given job

Fields

Name	Description	Type	Nullable
nightly_job_id	Primary key	PK	No
name	Unique name of the nightly job	String(64)	No
lock_count	0 when the job is not running; incremented when a server takes (or breaks a stale) lock, reset to 0 on release	Int	No
locked_at	When the current lock was taken; locks older than 24 hours are considered stale and may be broken	UtcDateTime	Yes
locked_by	Machine name of the server that took the current lock, for diagnostics	String(255)	Yes
next_run	Diagnostic only: when the job asked to be run next, as of its last run; not used for scheduling	UtcDateTime	Yes
last_exhaustive	When the job last completed an exhaustive run, i.e. processed all available data; or how far a later non-exhaustive run got	UtcDateTime	Yes
last_point_in_time	Job-specific progress marker, such as the last id processed, used to continue from where the previous run stopped	Int	No
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

Indexes

Fields	Types	Description
name	String(64)	Unique

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons

Replication Flags

None

Security Flags

No access control via user’s Role.