Page 1 of 1
Starting a job from PC
Posted: Wed Feb 08, 2012 2:53 pm
by danddmrs
Attempting to set up a user with capability to start a DS job from a PC that does not have the DataStage client installed. Copied DSJOB.exe, dsclnt32.dll, and dsrpc32.dll to the PC but message received is 'Access is denied'.
Is this because the user is not defined to the project on the DS server?
Posted: Wed Feb 08, 2012 4:07 pm
by kumar_s
Probably yes.
What is the full error message?
Posted: Wed Feb 08, 2012 6:31 pm
by ray.wurlod
What is the full syntax of the dsjob command that you are issuing? In particular does it include -user and -password options?
Posted: Thu Feb 09, 2012 8:23 am
by danddmrs
Thanks for replies, here is the command...
call \\LMDSTAGE1T.AAMHC.LOCAL\E$\Ascential\DataStage\Engine\bin\DSJOB -server lmdstage1t -run -jobstatus -param "OODServer=DUNFIK" -param "OODUserId=etl_dunfik" PeopleSoft UNFI_Allocation_SEQUENCER_InterUnit
Posted: Thu Feb 09, 2012 6:18 pm
by ray.wurlod
I thought you said you'd copied dsjob executable and its dlls. Why are you using call ?
Posted: Fri Feb 10, 2012 8:21 am
by danddmrs
Started with a command file used to start a DS job from the Zeke scheduler.
If I use the following I think it will want -user and -password for access to the DataStage server. Since the users don't have access to the DS servers they would need a user/password combo that would allow them access to start jobs. Our DS Admin won't give them access because they would need Admin privleges on the server (his take). I would think operator access would be sufficient to start a job.
C:\dsjob.exe -server lmdstage1t -run -jobstatus -param "OODServer=DUNFIK" -param "OODUserId=etl_dunfik" PeopleSoft UNFI_Allocation_SEQUENCER_InterUnit
Posted: Fri Feb 10, 2012 10:05 am
by qt_ky
Stick with a simple solution... Install the user-friendly DataStage Director client for those users and just like you said, the admin can grant the operator role for the new users so they can run jobs in a supported manner. No admin privileges required!