WakeOnLANDistributionJob Table

Wake on LAN distribution jobs control the distribution of a Wake on LAN task to the nearest distribution server for the targeted managed devices. The status of these distribution jobs is stored in the WakeOnLANDistributionJob table. Each row in the table represents a Wake on LAN job, which is any Wake on LAN task (or a subset of a Wake on LAN task), that has been distributed to a distribution server. Be aware: There can be multiple distribution jobs for a given Wake on LAN task.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for WakeOnLANDistributionJob table

Database Column



Type: binary (max 16 bytes). Key

A unique identifier for this distribution job.


Type: binary (max 16 bytes). Key

A unique identifier for the task that created this distribution job. This is a foreign key linked to the TaskUID in the WakeOnLANTask table.


Type: binary (max 16 bytes). Key

A unique identifier for the distribution server that this distribution job targets. This foreign key links to the ServerUID in the DistributionServer table.


Type: text (max 16 characters)

The state of this distribution job. This can be one of the following values: + Pending + Failed + Success