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
ketfos
Participant
Posts: 562 Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:
Post
by ketfos » Wed Oct 05, 2005 11:54 am
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
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Oct 05, 2005 12:29 pm
There's no
-project , it's
-ljobs and if you are on the same box as the server it's even easier:
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
Posts: 353 Joined: Wed Apr 06, 2005 8:45 am
Post
by vinaymanchinila » Wed Oct 05, 2005 1:20 pm
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 » Wed Oct 05, 2005 1:52 pm
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
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Oct 05, 2005 2:08 pm
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
Posts: 353 Joined: Wed Apr 06, 2005 8:45 am
Post
by vinaymanchinila » Wed Oct 05, 2005 2:10 pm
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 » Wed Oct 05, 2005 2:22 pm
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 » Wed Oct 05, 2005 5:08 pm
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
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Oct 05, 2005 6:37 pm
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
vinaymanchinila
Premium Member
Posts: 353 Joined: Wed Apr 06, 2005 8:45 am
Post
by vinaymanchinila » Thu Oct 06, 2005 7:31 am
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 » Thu Oct 06, 2005 8:25 am
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
ketfos
Participant
Posts: 562 Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:
Post
by ketfos » Thu Oct 06, 2005 11:05 am
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 » Thu Oct 06, 2005 12:38 pm
Hi,
Thanks Naveen for your help.
Ketfos