Forum Discussion

tocals's avatar
Level 4
12 years ago

How to list jobs PDOS (CLI)


Hello All.


Is there some command to list all PDOS jobs like bpdbjobs in NetBackup? I Was trying to create a similar report using the opsceter, but all clients recorded in the opscenter database has the client's name the puredisk server name.



2 Replies

Replies have been turned off for this discussion
  • Hi,

    There is a command available using PureDisk CLI:


    Command # ./pdlistjob

    Below is the link which can help if you need more information on other commands:


    Hope that helps !!

    Thank you.

  • PureDisk standard CLI is not that flexible as I would like it to be, but enjoy these:


    This should be more usefull and less verbose.

    1. List Data Selections:
    # export PGPASSWORD=`/opt/pdag/bin/php /opt/pdconfigure/upgrade/legacy/actions/doafter/GetEntry.php /etc/puredisk/spa.cfg spadb password`
    #  /opt/pddb/bin/psql -U pddb ca -c "select id,name,agentid,dstypeid from dataselection"

    2. List agents:
    # /opt/pddb/bin/psql -U pddb ca -c "select id,hostname,statustypeid,mbeid FROM agent where (isserveragent=0 and statustypeid >0)"

    3. Query the "constant" table for job status:
    # /opt/pddb/bin/psql -U pddb ca -c "select * from executionstatustype"

    4. Query for job type:
    # /opt/pdcli/calls # /opt/pddb/bin/psql -U pddb ca -c "select * from jobtype"

    5. Combining 3 and 4 you can query for all the jobs that have failed or were aborted by watchdog:
    # /opt/pddb/bin/psql -U pddb ca -c "select,job.workflowid,job.agentid,job.dsid,, from job,workflow,dataselection where (executionstatus=3 or executionstatus=8) and and"

    6. You may want to have just the numbers, so query for a numbers of jobs that: failed/aborted by watchdog/success with errors jobs

    # /opt/pddb/bin/psql -U pddb ca -t -c "select count( from job where executionstatus=3"
    Aborted by watchdog:
    # /opt/pddb/bin/psql -U pddb ca  -t -c "select count( from job where executionstatus=8"
    Success with errors:
    # /opt/pddb/bin/psql -U pddb ca -t -c 'select count( from job where executionstatus=6'

    7. List all jobs:
    # /opt/pddb/bin/psql -U pddb ca -c "select * from job"

    All those queries work(ed) for me at some point, I have not checked them "now" before pasting. This is a "non-supported" method. If you use "UPDATE" instead of select: you are on your own then. Be carefull with complicated queries as you may simply kill the DBMS hosting your SPA and MBE. Check the quotation marks and line breaks as this forum might have automatically affected it.

    Never the less: have fun :)