Dell NetWorker 19.9 Administration Guide

PDF

Querying the jobsdb for workflow job records

Each time that you start a workflow, NetWorker creates a single workflow job in the jobsdb. Run the jobquery command to display information about the workflow job.

To query the jobsdb for information about workflows in a policy, type the following command in the jobquery interface:

. type: workflow job; data protection policy name: policy_name; workflow name: workflow_name

where policy_name is the name of the policy that contains the workflow and workflow_name is the name of the workflow.

NOTE: The policy_name and workflow_name values are case sensitive.

For example, to query the jobsdb for a workflow named SQL Clients in a policy named Backup, type the following commands at the jobquery prompt:

jobquery>. type: workflow job; data protection policy name: Backup; workflow name: SQL Clients
jobquery>print

Output similar to the following appears:

type: workflow job; activity progress: 1/0/1; actual exit code: 1; adhoc job: False; authtype: ; automatic: False; Checkpoint restart ID: ; Checkpoint restart sequence: ; command: ; completion severity: 50; completion status: failed; data protection policy name: Backup; dependent job id: 0; end time: 1435107619; exit code known: True; host: bu-iddnwserver.iddlab.local; input flag: False; job id: 832031; job log file: \ "C:\\Program Files\\EMC NetWorker\\nsr\\logs\\policy\\Backup\\workflow_SQL clients_832031.raw"; job output: \ "133550 1435107602 1 0 0 3376 4996 0 bu-iddnwserver.iddlab.local nsrworkflow NSR notice 31 Starting %s '%s' workflow '%s'. 3 11 24 127405:Protection Policy \ 0 6 Backup 0 11 SQL clients 123316 1435107602 1 0 0 3376 4996 0 bu-iddnwserver.iddlab.local nsrworkflow NSR notice 46 Starting action '%s/%s/%s' with command: '%s'. 4 0 6 Backup 0 11 S\ QL clients 0 6 backup 0 32 savegrp -Z backup:traditional -v 123321 1435107602 1 0 0 3376 4996 0 bu-iddnwserver.iddlab.local nsrworkflow NSR notice 39 Action '%s/%s/%s's log will be in '%s'. 4 0 6 Backup 0 11 SQL clie\ nts 0 6 backup 23 83 C:\\Program Files\\EMC NetWorker\\nsr\\logs\\policy\\Backup\\SQL clients\\backup_832032.raw 123325 1435107619 1 0 0 3376 4996 0 bu-iddnwserver.iddlab.local nsrworkflow NSR notice 21 Action '%s/%s/%s' %s. 4 0 6 Backup 0 11 SQL clients 0 6 backup 0 6\ failed 133555 1435107619 1 0 0 3376 4996 0 bu-iddnwserver.iddlab.local nsrworkflow NSR notice 24 Workflow '%s/%s' failed. 2 0 6 Backup 0 11 SQL clients"; job state: COMPLETED; name: Backup; ndmp flag: False; NW Client name/id: ; override parameters: ; parent job id: 0; policy definition changetime: 1434655597016534; previous job id: 0; protection groups: SQL clients; Reason job was terminated: ; redirect stdio: False; remote password: ; remote user: ; restricted data zone: ; root parent job id: 0; savegrp spawned: False; sibling job id: ; SSID: ; start time: 1435107602; type attributes: ; type classes: ; type help: ; type name: ; type references: ; type table: ; userid: ; workflow name: SQL clients;

The following table summarizes some of the attributes that appear in workflow job types.

Table 1. Workflow-specific job record attributes
Attribute	Description
Job id	A unique number value that identifies the job.
Parent job id	The job id of the job that started this job. A job may not have a parent job.
Job state	The status of the job. Status values include: CREATED, QUEUED, STARTED, ACTIVE, SESSION ACTIVE, CANCELLED, and COMPLETED.
Job log file	The location and name of the log file that contains detailed information about the job activities.
Job output	The information that is contained in the `job log file`. NOTE:Truncation of the content might occur when the file is large, which results in only displaying the last 2 KB of information.
Start time	The time the job started, in seconds since Jan 1, 1970.
End time	The time the job ended, in seconds since Jan 1, 1970.
Completion status	The completion status set by the job. Status values include never started, did not run, succeeded, failed, abandoned, canceled, and communication lost between job and nsrjobd.
Completion severity	The severity level of any error that caused the job to end. Severity levels include: EMERGENCY, ALERT, CRITICAL, SEVERE, ERROR, INTERVENTION, WARNING, NOTICE, and INFORMATION.
Data protection policy name	The name of the policy that contains the workflow.
Workflow name	The name of the Workflow resource.
Override parameters	A list of parameters that were configured in the Workflow resource, when the workflow started. Use override parameters to override the value that is defined for an equivalent action property.
Protection groups	The protection groups that are assigned to the workflow.
Restricted datazone	The datazone to which the resource is assigned.
Policy definition changetime	The last change time of the policy that contains the workflow.
Previous jobid	The job id of the instance of a restarted workflow.