HI All,
May I know how to start the datastage jobs using window bat file or MS DOS prompt???
I believe that we can do that like unix shell script.Am I right?
Thanks,
HOw to start the datastage job from win bat file or DOS mode
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 81
- Joined: Mon Nov 21, 2005 4:17 am
- Location: Sydney, Australia
- Contact:
To Start DS Job from a batch file of windows
Hi,
I gues this should help you when you put this in a batch.
C:\Ascential\DataStage\Engine\bin\dsjob -server <server_name> -user <User_Name> -password <somepwd> -run <Project_Name> <Job_Name>
Regards,
Suresh N
I gues this should help you when you put this in a batch.
C:\Ascential\DataStage\Engine\bin\dsjob -server <server_name> -user <User_Name> -password <somepwd> -run <Project_Name> <Job_Name>
Regards,
Suresh N
SURESH NARASIMHA
-
- Premium Member
- Posts: 4
- Joined: Thu Feb 26, 2004 3:08 pm
An example in a ".bat" file
:runjob
C:\Ascential\DataStage\Engine\Bin\dsjob -file %fname% %rserver% -run -jobstatus %project% %job%
::
if not errorlevel 2 goto end
C:\Ascential\DataStage\Engine\Bin\dsjob -file %fname% %rserver% -run -mode RESET %project% %job%
C:\Ascential\DataStage\Engine\Bin\dsjob -file %fname% %rserver% -logsum -type INFO -max 50 %project% %job%
::
where
%fname contains the userid/pwd in a file
%rserver is the server name
%project is the ds project name
%job is the job you are running
The 1st dsjob runs the job
The 2nd Resets the job if it abends
The 3rd dumps parts of the log file
Hope that helps.
C:\Ascential\DataStage\Engine\Bin\dsjob -file %fname% %rserver% -run -jobstatus %project% %job%
::
if not errorlevel 2 goto end
C:\Ascential\DataStage\Engine\Bin\dsjob -file %fname% %rserver% -run -mode RESET %project% %job%
C:\Ascential\DataStage\Engine\Bin\dsjob -file %fname% %rserver% -logsum -type INFO -max 50 %project% %job%
::
where
%fname contains the userid/pwd in a file
%rserver is the server name
%project is the ds project name
%job is the job you are running
The 1st dsjob runs the job
The 2nd Resets the job if it abends
The 3rd dumps parts of the log file
Hope that helps.
Dear U,
Could u pls chk ur private msg?
Thanks,
Could u pls chk ur private msg?
Thanks,
U wrote:Please don't let me delay your search for someone who cares.ICE wrote:Dear All,
Thank u so much.Thanks a lot.
I will try and let u know then.
I really appreciate you all advise.
Thanks a lot..
U is my name.
"YOU" is a personal pronoun.
Please get it right.