Skip to content

dx_get_jobs

Marcin Przepiorowski edited this page Jan 10, 2019 · 6 revisions

SYNOPSIS

dx_get_jobs    [ -engine|d <delphix identifier> | -all ] [ -configfile file ]
               [-jobref ref]
               [-st timestamp]
               [-et timestamp]
               [-dbname name]
               [-group group]
               [-host hostname]
               [-type VDB|dSource]
               [-dSource name]
               [-state state]
               [-errDetails]
               [-format csv|json ]
               [-outdir path]
               [-help|? ] [ -debug ]

DESCRIPTION

Get the list of jobs from Delphix Engine.

ARGUMENTS

Delphix Engine selection - if not specified a default host(s) from dxtools.conf will be used.

  • -engine|d Specify Delphix Engine name from dxtools.conf file
  • -all Display databases on all Delphix appliance
  • -configfile file Location of the configuration file. A config file search order is as follow:
  • configfile parameter
  • DXTOOLKIT_CONF variable
  • dxtools.conf from dxtoolkit location

Filters

Filter faults using one of the following filters

  • -state Job state - COMPLETED / FAILED / RUNNING / SUSPENDED / CANCELED
  • -jobref ref Job reference

OPTIONS

  • -st timestamp Start time for faults list - default value is 7 days
  • -et timestamp End time for faults list
  • -group group Database group Name
  • -dbname name Database Name
  • -host host Database host Name
  • -type type Type (dsource|vdb)
  • -dsource name Name of dSource
  • -errDetails Display an error details for a failed jobs
  • -format Display output in csv or json format If not specified pretty formatting is used.
  • -outdir path Write output into a directory specified by path. Files names will include a timestamp and type name
  • -help Print this screen
  • -debug Turn on debugging
  • -nohead Turn off header output

EXAMPLES

Print jobs from Delphix Engine

dx_get_jobs -d Landshark5

Appliance            Job ref         Target name          Username             Start date                     End date                       Run time   State        Type
-------------------- --------------- -------------------- -------------------- ------------------------------ ------------------------------ ---------- ------------ --------------------
Landshark5           JOB-7753        Test/vFiles          N/A                  2016-11-01 17:20:10 GMT        2016-11-01 17:20:11 GMT        00:00:01   COMPLETED    DB_SYNC
Landshark5           JOB-7754        Test/vFiles          N/A                  2016-11-02 08:27:37 GMT        2016-11-02 08:27:37 GMT        00:00:00   COMPLETED    DB_SYNC
Landshark5           JOB-7755        Analytics/VOra_744   delphix_admin        2016-11-08 12:28:52 GMT        2016-11-08 12:29:19 GMT        00:00:27   CANCELED     DB_PROVISION
Landshark5           JOB-7756        VOra_744             delphix_admin        2016-11-08 12:29:03 GMT        2016-11-08 12:29:19 GMT        00:00:16   COMPLETED    SOURCE_DISABLE
Landshark5           JOB-7757        VOra_744             delphix_admin        2016-11-08 12:29:10 GMT        2016-11-08 12:29:19 GMT        00:00:09   COMPLETED    SOURCE_STOP
Landshark5           JOB-7758        Analytics/VOra_744   delphix_admin        2016-11-08 12:32:21 GMT        2016-11-08 12:32:22 GMT        00:00:01   COMPLETED    DB_DELETE

Print jobs for database "cont1" since 2016-10-01

dx_get_jobs -d Landshark5 -dbname cont1 -st "2016-10-01"

Appliance            Job ref         Target name          Username             Start date                     End date                       Run time   State        Type
-------------------- --------------- -------------------- -------------------- ------------------------------ ------------------------------ ---------- ------------ --------------------
Landshark5           JOB-7694        Analytics/cont1      delphix_admin        2016-10-24 19:13:47 IST        2016-10-24 19:15:21 IST        00:01:34   COMPLETED    DB_PROVISION
Landshark5           JOB-7696        Analytics/cont1      delphix_admin        2016-10-24 19:15:18 IST        2016-10-24 19:15:21 IST        00:00:03   COMPLETED    DB_SYNC
Landshark5           JOB-7700        Analytics/cont1      delphix_admin        2016-10-24 19:21:20 IST        2016-10-24 19:21:21 IST        00:00:01   COMPLETED    DB_SYNC
Landshark5           JOB-7702        Analytics/cont1      delphix_admin        2016-10-24 19:21:25 IST        2016-10-24 19:22:55 IST        00:01:30   COMPLETED    DB_REFRESH
Landshark5           JOB-7710        Analytics/cont1      delphix_admin        2016-10-24 19:22:56 IST        2016-10-24 19:22:59 IST        00:00:03   COMPLETED    DB_SYNC
Landshark5           JOB-7712        Analytics/cont1      N/A                  2016-10-25 08:30:00 IST        2016-10-25 08:30:01 IST        00:00:01   COMPLETED    DB_SYNC
Landshark5           JOB-7717        Analytics/cont1      dev                  2016-10-25 08:38:01 IST        2016-10-25 08:38:02 IST        00:00:01   COMPLETED    DB_SYNC
Landshark5           JOB-7719        Analytics/cont1      dev                  2016-10-25 08:38:06 IST        2016-10-25 08:39:36 IST        00:01:30   COMPLETED    DB_REFRESH
Landshark5           JOB-7721        Analytics/cont1      dev                  2016-10-25 08:39:36 IST        2016-10-25 08:39:39 IST        00:00:03   COMPLETED    DB_SYNC
Landshark5           JOB-7723        Analytics/cont1      dev                  2016-10-25 08:41:33 IST        2016-10-25 08:41:34 IST        00:00:01   COMPLETED    DB_SYNC
Landshark5           JOB-7725        Analytics/cont1      dev                  2016-10-25 08:42:11 IST        2016-10-25 08:42:12 IST        00:00:01   COMPLETED    DB_SYNC

Print jobs for all VDB based on dSource "Oracle dsource"

dx_get_jobs -d Landshark5 -dsource "Oracle dsource"

Appliance            Job ref         Target name          Username             Start date                     End date                       Run time   State        Type
-------------------- --------------- -------------------- -------------------- ------------------------------ ------------------------------ ---------- ------------ --------------------
Landshark5           JOB-7795        Analytics/test       delphix_admin        2016-11-08 13:11:45 GMT        2016-11-08 13:13:03 GMT        00:01:18   COMPLETED    DB_PROVISION
Landshark5           JOB-7796        Analytics/test       delphix_admin        2016-11-08 13:13:00 GMT        2016-11-08 13:13:03 GMT        00:00:03   COMPLETED    DB_SYNC
You can’t perform that action at this time.