dsjob -ljobs not working
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
dsjob -ljobs not working
Hi,
Total number of jobs in the project =100
10 jobs created with in the project
90 jobs exported with executables from the different environment and imported in this environment.
${DSJob} -server :30012 -ljobs project_name
i am using the above command for listing all the jobs in the project.
But it is listing only 10 jobs the remaining jobs it is showing as warning.
Status code = -1002
ERROR: Failed to open project
Any help greatly appricated
Thanks
Suresh
Total number of jobs in the project =100
10 jobs created with in the project
90 jobs exported with executables from the different environment and imported in this environment.
${DSJob} -server :30012 -ljobs project_name
i am using the above command for listing all the jobs in the project.
But it is listing only 10 jobs the remaining jobs it is showing as warning.
Status code = -1002
ERROR: Failed to open project
Any help greatly appricated
Thanks
Suresh
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Re: dsjob -ljobs not working
Try only
dsjob -ljobs PROJECT_NAME
dsjob -ljobs PROJECT_NAME
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
- Checked the permission of the user. Full permissions given for the user. i am unable to track the problem.
tried with below syntax
Used direct path but still facing the same.
Code: Select all
$DSHOME/bin/dsjob -server :30012 -ljobs project_Name
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Project name is case sensitive. Make sure it is spelled and cased correctly.
You also seem to have provided an empty server name. This may be the problem. You really need something like -server servername:portnumber even if the servername is localhost.
I suspect also that, if you use -server option in version 8, you also need to provide the -domain option.
You also seem to have provided an empty server name. This may be the problem. You really need something like -server servername:portnumber even if the servername is localhost.
I suspect also that, if you use -server option in version 8, you also need to provide the -domain option.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
Connecting to data stage designer tool passing host name : abcd0012.cust.systems.co:9080
Project name: abcd:30012/cust_prd_proj
While executing dsjob command
Project name: cust_prd_proj
server name:abcd0012
It is showing as syntax error
Command Syntax:
dsjob [-file <file> <server> | [-server <server>][-user <user>][-password <password>]]
<primary command> [<arguments>]
Valid primary command options are:
-run
-stop
-lprojects
-ljobs
-linvocations
-lstages
-llinks
-projectinfo
-jobinfo
-stageinfo
-linkinfo
-lparams
-paraminfo
-log
-logsum
-logdetail
-lognewest
-report
-jobid
-import
Status code = -9999 DSJE_DSJOB_ERROR
then tried with another options still facing the syntax error.
Project name: cust_prd_proj
Server name: abcd0012
Please share how to use the -domain option in the dsjob command.
I have not found in the data stage parallel guide for syntax.
Project name: abcd:30012/cust_prd_proj
While executing dsjob command
Project name: cust_prd_proj
server name:abcd0012
Code: Select all
${DSJob} -server abcd0012:30012 -domain -ljobs cust_prd_proj
Command Syntax:
dsjob [-file <file> <server> | [-server <server>][-user <user>][-password <password>]]
<primary command> [<arguments>]
Valid primary command options are:
-run
-stop
-lprojects
-ljobs
-linvocations
-lstages
-llinks
-projectinfo
-jobinfo
-stageinfo
-linkinfo
-lparams
-paraminfo
-log
-logsum
-logdetail
-lognewest
-report
-jobid
-import
Status code = -9999 DSJE_DSJOB_ERROR
then tried with another options still facing the syntax error.
Project name: cust_prd_proj
Server name: abcd0012
Code: Select all
Option 1 ${DSJob} -server abcd0012:30012 -domain -ljobs cust_prd_proj
Option 2 ${DSJob} -domain -server abcd0012:30012 -ljobs cust_prd_proj
I have not found in the data stage parallel guide for syntax.
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
Hi,
we are able to list the jobs using dsjob command.
Resolution:
Changed the shell script dsenv path and tested, it is working fine.
But now in the server routine we are using the below command to run the jobs
Tried with the below options.
Option1) existing i have used to run the data stage jobs using a routine.
Option2) We are unable to execute the routne beacuse we are using instance( :30012). i am using value with colon(:30012). so i want skip the colon and run the routine. what is the standard syntax i have to use in the routine.colon is treating as concatenation in the below. how to escape the colon in the below command
we are able to list the jobs using dsjob command.
Resolution:
Changed the shell script dsenv path and tested, it is working fine.
Code: Select all
${DSJob} -server :30012 -ljobs project_name
Tried with the below options.
Option1) existing i have used to run the data stage jobs using a routine.
Code: Select all
DSJobCmd = WorkingDir : 'dsjob -server ' : Server : ' -run ' : Parameters : ' -warn ' : WarnLimit : ' -rows ' : RowLimit : ' ' : Projectname : ' ' :
JobName
Code: Select all
DSJobCmd = WorkingDir : 'dsjob -server ' : Server:':30012 -run ' : Parameters : ' -warn ' : WarnLimit : ' -rows ' : RowLimit : ' ' : Projectname : ' ' : JobName
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
After taking notes on your valuable suggestions and tried with many possibilities.
Finally got the solution on this. this is closed.
Thanks,
Suresh
Finally got the solution on this. this is closed.
Code: Select all
DSJobCmd = WorkingDir : 'dsjob -server :30012' : ' -run ' : Parameters : ' -warn ' : WarnLimit : ' -rows ' : RowLimit : ' ' : Projectname : ' ' : JobName
Suresh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: