DSJOB command in UNIX

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

DSJOB command in UNIX

Post by ketfos »

Hi,
I am trying to find list of all the jobs in the current project using dsjob command on UNIX

dsjob -server hp113 -user ksstage -password kspass -projects dev -jobs

I am getting the error message Status code = -9999 DSJE_DSJOB_ERROR

Can somebody let me know the exact syntax.
I tried using Search Forum but could not get it running using the syntax/help availabe in it.

Thanks
Ketfos
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

There's no -project, it's -ljobs and if you are on the same box as the server it's even easier:

Code: Select all

dsjob -ljobs dev
If you issue the command without arguments, it will dump out a normal 'usage' type message.
-craig

"You can never have too many knives" -- Logan Nine Fingers
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Hi,
There is a job that runs between 1-2Am and that is our backup window time. Is there a way to find out which job it i s?

Have looked carefully in the director and there is none scheduled to run or jobs that spill over to 1AM.
Thanks,
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

Post by ketfos »

Hi Chulett,
There are multipe projects on the Unix box.
When I issue the command you gave
it gave me an error message

dsjob -ljobs dev

Status code = -1002

Ketfos
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

As do I and it works fine for me - and I assumed that dev was one of your project names, is it? :?

If you need to, try it with the server / userid / password keywords as well.
-craig

"You can never have too many knives" -- Logan Nine Fingers
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Hi Chulett,
Any ideas onhow to deal with

There is a job that runs between 1-2Am and that is our backup window time. Is there a way to find out which job it i s?

Have looked carefully in the director and there is none scheduled to run or jobs that spill over to 1AM.

Thanks,
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

Post by ketfos »

Hi vinaymanchinila,

If your DS Server is Unix, there should be an entry in crontab for this scheduled job.
So look up in Unix using crontab -l.

It will ahve a entry for this job if it is scheduled.

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

Post by ray.wurlod »

Schedule a ps -ef | grep ds | grep -v grep > /tmp/what_is_the_job command to run at 01:10. Use this to identify the job from its command line.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

vinaymanchinila wrote:Have looked carefully in the director and there is none scheduled to run or jobs that spill over to 1AM.
In addition to the other advice, note that the Director only shows schedule information if the jobs have been scheduled by whomever you are currently logged in as.

If you have multiple userids scheduling jobs, each has their own crontab in UNIX. If you are not sure who would have scheduled it then Ray's suggestion is user agnostic and should capture a picture of the trespasser. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Thanks a bunch , we are in the process of looking into all the corn tabs!
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

mmmm corn tabs
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

crontab I mean :P
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

Post by ketfos »

Hi Naveen,
Yes your command works and thanks so much.
I need one more thing.
How do I get log information for a job named 'testjob' under this project using dsjob command on Unix prompt.

Ketfos
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

Post by ketfos »

Hi,
Thanks Naveen for your help.

Ketfos
Post Reply