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?
Starting a job from PC
Moderators: chulett, rschirm, roy
-
- 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:
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
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
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!
Choose a job you love, and you will never have to work a day in your life. - Confucius