Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Dell Financial Services Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

Dell NetWorker 19.9 Administration Guide

PDF

Querying the jobdb for action records

Each time that an action starts, NetWorker creates a job record for the action in the jobsdb. Some actions create child actions, for example a backup action creates a save job and a savefs job. Each child action has a unique job record. Use the jobquery command to display information about an action job.

To query the jobdb for information about an action job, type the following command in the jobquery interface:

. type:action_name

where action_name is the name of the action.

For example, to query the jobdb for a bootstrap save job, type the following commands at the jobquery prompt:

jobquery>. type: bootstrap save job
jobquery>print

Output similar to the following appears:

                        type: bootstrap save job;
            actual exit code: 0;
                   adhoc job: False;
                    authtype: ;
                   automatic: False;
        canceled input count: 0;
   canceled input work items: ;
       Checkpoint restart ID: ;
Checkpoint restart sequence: ;
                     command: nsrdbsave -l 1;
      completed output count: 0;
completed output work items: ;
         completion severity: 50;
           completion status: failed;
data protection policy name: Server Protection;
                   data size: ;
            dependent job id: 0;
                    end time: 1434895738;
             exit code known: True;
          failed input count: 2;
     failed input work items: bu-iddsql.corp.com,
                              bu-iddnwserver.iddlab.local;
                  file count: ;
        filtered input count: 0;
   filtered input work items: ;
          hard runtime limit: 0;
                        host: bu-iddnwserver.iddlab.local;
                  input flag: True;
                input job id: ;
                      job id: 800020;
                job log file: \
"C:\\Program Files\\EMC NetWorker\\nsr\\logs\\policy\\Server Protection\\Serve\
r backup\\Server db backup_800020.raw";
                  job output: \
"suppressed 799 bytes of output.
140403 1434808808 1 5 0 2284 2280 0 bu-iddnwserver.iddlab.local nsrdbsave NSR notice 55 Started '%s' job with jobid [%u]. Backup command:\\n %s. 3 0 12 inde\
x backup 5 6 800022 0 367 save -q -e \"1 Months\" -b Default -J bu-iddnwserver.iddlab.local -a \"*policy name=Server Protection\" -a \"*policy workflow name\
=Server backup\" -a \"*policy action name=Server db backup\" -g \"Server Protection\" -l full -S -f - -LL -W 78 -N index:2668af1d-00000004-54528c1a-5452a19b\
-00155000-7396bc56 -x \"C:\\\\Program Files\\\\EMC NetWorker\\\\nsr\\\\index\\bu-iddsql.corp.com\"
140402 1434895685 1 5 0 2284 2280 0 bu-iddnwserver.iddlab.local nsrdbsave NSR notice 35 Completed '%s' job with jobid [%u]. 2 0 12 index backup 5 6 800022
140402 1434895738 1 5 0 2284 2280 0 bu-iddnwserver.iddlab.local nsrdbsave NSR notice 35 Completed '%s' job with jobid [%u]. 2 0 12 index backup 5 6 800021
112777 1434895738 5 3 13 2200 1572 0 bu-iddnwserver.iddlab.local nsrd RAP critical 119 Permission denied, application provided an expired session ticket; us\
er '%s' on '%s', cur time %s, expiration time %s . 4 13 6 SYSTEM 12 27 bu-iddnwserver.iddlab.local 35 10 1434895738 35 10 1434812401
138211 1434895738 3 0 0 2284 2280 0 bu-iddnwserver.iddlab.local nsrdbsave NSR error 33 Verify that NetWorker is running. 0
140403 1434895738 1 5 0 2284 2280 0 bu-iddnwserver.iddlab.local nsrdbsave NSR notice 55 Started '%s' job with jobid [%u]. Backup command:\\n %s. 3 0 10 mmin\
fo_job 5 6 800040 0 9 mminfo -B 140402 1434895738 1 5 0 2284 2280 0 bu-iddnwserver.iddlab.local nsrdbsave NSR \
notice 35 Completed '%s' job with jobid [%u]. 2 0 10 mminfo_job 5 6 800040 140407 1434895738 1 5 0 2284 2280 0 bu-iddnwserver.iddlab.local nsrdbsave NSR \
notice 48 See the file '%s' for detail output of each job. 1 0 107 C:\\Program Files\\EMC NetWorker\\nsr\\logs\\policy\\Server Protection\\Server backup\\Se\
";er db backup_800020_logs
                   job state: COMPLETED;
                       level: ;
                        name: nsrdbsave;
                   ndmp flag: False;
             number of files: ;
           NW Client name/id: ;
         override parameters: ;
                 parallelism: 0;
               parent job id: 800019;
          policy action name: Server db backup;
             previous job id: 0;
   Reason job was terminated: ;
              redirect stdio: True;
             remote password: ;
                 remote user: SYSTEM;
        restricted data zone: ;
          root parent job id: 800019;
         running input count: 0;
    running input work items: ;
             savegrp spawned: False;
                  saveset id: ;
              sibling job id: ;
                        size: ;
          soft runtime limit: 0;
                        SSID: ;
                  start time: 1434808802;
      successful input count: 0;
successful input work items: ;
             type attributes: ;
                type classes: ;
                   type help: ;
                   type name: ;
             type references: ;
                  type table: ;
                      userid: ;
         waiting input count: 0;
    waiting input work items: ;
               workflow name: Server backup;

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

Table 1. Action 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 contained in the job log file.
NOTE:Truncation of the content might occur when the file is large.
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 action.
Workflow name The name of the Workflow resource that contains the action.
Policy action name The name of the action.
Input job id The job id of the action that is controlling this action.
Waiting input work items For the first or head action in a workflow, this is a list of work items for the protection group that is assigned to the workflow that contains the head action. For subsequent actions, this list displays the value in the completed output work items attribute, for the action that precedes this action. When an action starts a work item, the work item value moves from the waiting input work items attribute to the running input work items attribute.
Waiting input count The number of work items in the waiting input work items attribute.
Filtered input work items Contains work items that an action has filtered out of the waiting input work items attribute.
Filtered input count The number of work items in the filtered input work items attribute.
Running input work items A list of in progress work items that were previously in the waiting input work items attribute. This list does not display in progress work items that were previously in the filtered input work items attribute.
Running input count The number of work items in the running input work items attribute.
Successful input work items A list of input work items that have completed successfully. When an input work item completes successfully, the value moves from the running input work items to the successful input work items attribute.
Successful input count The number of work items in the successful input work items attribute.
Failed input work items A list of input work items that have not completed successfully. When an input work item does not complete successfully, the value moves from the running input work items to the failed input work items attribute.
Failed input count The number of work items in the failed input work items attribute.
Canceled input work items A list of input work items that were canceled and did not complete. When an input work item is canceled, the value moves from the running input work items to the cancelled input work items attribute.
Canceled input count The number of work items in the cancelled input work items attribute.
Completed output work items The list of work items that are produced by this action.
Completed output count The number of work items in the completed output work items attribute.

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\