Finding Job Type using command line (dsjob)

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
stss
Participant
Posts: 1
Joined: Tue Jul 18, 2017 10:05 am

Finding Job Type using command line (dsjob)

Post by stss »

I am in need of identifying the type of job using dsjob. I searched over and over in the forum and on google but could not know which option to use.

I am sure it must be in jobinfo or in report but I haven't got a clue even after 2 hours of searching.

Please do help me.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard.

I'm not sure it's possible with dsjob command.

The job type is easily reported on from a dssh shell, running a query against the DS_JOBS table.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Agreed. It does not look like dsjob has that capability.

In theory, the dssearch command should be able to provide lists of jobs within a project, per job type. Example:

Code: Select all

bin/dssearch -ljobs -matches -jobtype parallel project_name
Options output by the command:

Code: Select all

dssearch -ljobs -matches
                        [-sub[categories]
                        [-c[ategory] <category>]
                        [-j[obtype] s[erver] | p[arallel] | m[ainframe] | seq[uence]]
                        [-oc[ategory]]
                        [-oj[obtype]]
                        <project> [<job search criteria>]
I tried several tests and variations using the -jobtype or -j options on 11.3.x but was unable to get expected results. Perhaps I was doing something wrong, or perhaps the command no longer works. At best I got output like this:

Code: Select all

<none>

Status code = 0
Choose a job you love, and you will never have to work a day in your life. - Confucius
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

An exact search here for JOBTYPEIND will turn up discussion of the solution Ray mentioned.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply