Executing and Scheduling dsexport or dscmd on server
Moderators: chulett, rschirm, roy
Executing and Scheduling dsexport or dscmd on server
Hi,
I try to sehedule dsexport from command line,but its not kicking on schedule time.Here is the command i'm using to schedule.
command : C:\Program Files\Ascential\DataStage7.5.1>AT 23:00 /NEXT:M,T,W,TH,F dsexport /H=
abc.com /U=xxxx /P=xxxx datawarehouse C:\DSBACKUP\dwhouse_%date
:~4,2%%date:~7,2%%date:~10,4%.dsx
Looks i miss some thing in this command..
Apprecite further ideas on this..
Hary
I try to sehedule dsexport from command line,but its not kicking on schedule time.Here is the command i'm using to schedule.
command : C:\Program Files\Ascential\DataStage7.5.1>AT 23:00 /NEXT:M,T,W,TH,F dsexport /H=
abc.com /U=xxxx /P=xxxx datawarehouse C:\DSBACKUP\dwhouse_%date
:~4,2%%date:~7,2%%date:~10,4%.dsx
Looks i miss some thing in this command..
Apprecite further ideas on this..
Hary
Last edited by har on Tue Feb 14, 2006 10:21 am, edited 2 times in total.
Har
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
Re: Scheduling dsexport from command line
Don't you have to quote the command when doing at?
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
Hi Hary,
'AT' kicks off a bat file properly without any error.
So you can create another .bat file which just holds
dsexport /H=
abc.com /U=xxxx /P=xxxx datawarehouse C:\DSBACKUP\dwhouse_%date
:~4,2%%date:~7,2%%date:~10,4%.dsx
say DSEXP.bat
C:\Program Files\Ascential\DataStage7.5.1>AT 23:00 /NEXT:M,T,W,TH,F DSEXP.bat works :D
After crossing the scheduling time, the status of the execution can known by typing the comand 'AT'. Status may return Error if it doesnt triggered correctly.
You can also know the exact command that has been scheduled. I guess the command might be just 'dsexport' in your case
-Kumar
'AT' kicks off a bat file properly without any error.
So you can create another .bat file which just holds
dsexport /H=
abc.com /U=xxxx /P=xxxx datawarehouse C:\DSBACKUP\dwhouse_%date
:~4,2%%date:~7,2%%date:~10,4%.dsx
say DSEXP.bat
C:\Program Files\Ascential\DataStage7.5.1>AT 23:00 /NEXT:M,T,W,TH,F DSEXP.bat works :D
After crossing the scheduling time, the status of the execution can known by typing the comand 'AT'. Status may return Error if it doesnt triggered correctly.
You can also know the exact command that has been scheduled. I guess the command might be just 'dsexport' in your case
-Kumar
hi,
I tried with these scenarios,but i unable to schedule the script..
Scenario:
1.C:\Program Files\Ascential\DataStage7.5.1>AT 23:00 /NEXT:M,T,W,TH,F dsexport /H=
"abc.com /U=xxxx /P=xxxx datawarehouse C:\DSBACKUP\dwhouse_%date :~4,2%%date:~7,2%%date:~10,4%.dsx"
2.C:\Program Files\Ascential\DataStage7.5.1>AT 23:00 /NEXT:M,T,W,TH,F 'dsexport' /H=
abc.com /U=xxxx /P=xxxx datawarehouse C:\DSBACKUP\dwhouse_%date
:~4,2%%date:~7,2%%date:~10,4%.dsx
3.Icreated a Test.bat file and scheduled,still its not running.
Thanks,
hary
I tried with these scenarios,but i unable to schedule the script..
Scenario:
1.C:\Program Files\Ascential\DataStage7.5.1>AT 23:00 /NEXT:M,T,W,TH,F dsexport /H=
"abc.com /U=xxxx /P=xxxx datawarehouse C:\DSBACKUP\dwhouse_%date :~4,2%%date:~7,2%%date:~10,4%.dsx"
2.C:\Program Files\Ascential\DataStage7.5.1>AT 23:00 /NEXT:M,T,W,TH,F 'dsexport' /H=
abc.com /U=xxxx /P=xxxx datawarehouse C:\DSBACKUP\dwhouse_%date
:~4,2%%date:~7,2%%date:~10,4%.dsx
3.Icreated a Test.bat file and scheduled,still its not running.
Thanks,
hary
Har
-
- Participant
- Posts: 21
- Joined: Fri Nov 04, 2005 11:31 am
'AT' takes only only one paramter at a time from command line.
By giving
>AT 23:00 /NEXT:M,T,W,TH,F dsexport /H= "abc.com....
or
>AT 23:00 /NEXT:M,T,W,TH,F 'dsexport' /H= "abc.com
Should be shecdling only the dsexport command without any other paramters needed to it. That is the reason, you were repeatedly asked to let know the result of AT which will give the list of commands that have been scheduled at different time.
-Kumar
By giving
>AT 23:00 /NEXT:M,T,W,TH,F dsexport /H= "abc.com....
or
>AT 23:00 /NEXT:M,T,W,TH,F 'dsexport' /H= "abc.com
Should be shecdling only the dsexport command without any other paramters needed to it. That is the reason, you were repeatedly asked to let know the result of AT which will give the list of commands that have been scheduled at different time.
-Kumar
is it possible to run dscmd or dsexport on server..?
Hi guys,
I can export whole project using dscmd or dsexport from client.And i can schedule the dscmd.Same way i want to do on server...
Is it possible to run same command on server..?
I check Ascential pdf,but i didnt find any thing.
hary
I can export whole project using dscmd or dsexport from client.And i can schedule the dscmd.Same way i want to do on server...
Is it possible to run same command on server..?
I check Ascential pdf,but i didnt find any thing.
hary
Har