Hi,
I have used dsjob command to trigger the job in my server routine.
First of all I am checking the whether the job is in compiled/finished/aborted status using dsjob -jobstatus command.
If the job is in aborted state, i am going to reset the job.
But my problem is the dsjob -jobstatus which i have used to get the status of the job is not returning me the result for long time more than 30mins and getting hanged.
Especially when i use the dsjob command with -file switch, it is hanging. I have stored the datastage credentials in a file and given the path to it.
What could be the issue. I need a very urgent help on this.
Thanks in advance.
dsjob command getting hanged when -jobstatus option is used.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 22
- Joined: Thu Apr 19, 2012 3:31 am
- Location: India
dsjob command getting hanged when -jobstatus option is used.
Regards,
Sai Krishna
Sai Krishna
Re: dsjob command getting hanged when -jobstatus option is u
That option is actually used to run a job and then wait until it is complete before passing back the status of the job. You need to be using "-jobinfo" instead and then grep'ing through the results to determine what happened the last time the job was run.saiwelcomes wrote:I have used dsjob command to trigger the job in my server routine.
First of all I am checking the whether the job is in compiled/finished/aborted status using dsjob -jobstatus command.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 22
- Joined: Thu Apr 19, 2012 3:31 am
- Location: India
-
- Participant
- Posts: 22
- Joined: Thu Apr 19, 2012 3:31 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 22
- Joined: Thu Apr 19, 2012 3:31 am
- Location: India
Hi ray,
This is the code snippet used to get the jobinfo in my routine.
cmd$DSENV = "cd '":p_DSHOME_DIR:"'":char(10) ;
cmd$DSENV := ". ./dsenv":char(10) ;
reconJob$Status = cmd$DSENV
reconJob$Status := "dsjob -file '":EV_SCRIPTS_DIR:"'/'":DS_ENV_INFO_FILE:"' '":DS_DOMAIN:"' '":DS_SERVER:"' -jobinfo '":DS_PROJECT_NAME:"' '":JobName:"'"
Call DSExecute("UNIX", reconJob$Status,OsOutput$Status, OsStatus$Status)
DS_ENV_INFO_FILE param is file with .sh extension having domain,server,user,password information.
This is the code snippet used to get the jobinfo in my routine.
cmd$DSENV = "cd '":p_DSHOME_DIR:"'":char(10) ;
cmd$DSENV := ". ./dsenv":char(10) ;
reconJob$Status = cmd$DSENV
reconJob$Status := "dsjob -file '":EV_SCRIPTS_DIR:"'/'":DS_ENV_INFO_FILE:"' '":DS_DOMAIN:"' '":DS_SERVER:"' -jobinfo '":DS_PROJECT_NAME:"' '":JobName:"'"
Call DSExecute("UNIX", reconJob$Status,OsOutput$Status, OsStatus$Status)
DS_ENV_INFO_FILE param is file with .sh extension having domain,server,user,password information.
Regards,
Sai Krishna
Sai Krishna
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: