Table OV_PM_Job

The table OV_PM_Job contains data about all the deployment jobs that are currently in the queue. Records in this table are cascaded, and so removed automatically when the corresponding managed node is removed.

Column Name	Constraint	Column Type	Description
JobId	PK, I1	int	ID of the deployment job.
NodeId	FK1	nvarchar(64)	ID of the node for which the job is scheduled.
JobState		int	Current state of the deployment job.
JobType		int	Type of the deployment job (for example, install policy, remove package, redeploy node, and so on).
JobData		ntext	Any data that is needed to recover the job from the DB when the Policy Management server is started.
JobOptions		int	Options that have been specified for this deployment job.
SchedulingData		datetime	Date and time when the job was added to the queue.
ErrorDescription		nvarchar(1536)	If the job has failed for some reason, this column contains the error description string.
InstanceId		uniqueidentifier	ID of the object for which this job is scheduled (for example, policy or package version ID).