DSXchange

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

What gets listed when you just type "at" without options? How does your job look in the schedule?

Don't you have to quote the command when doing at?

It is easier to schedule DataStageBackup.bat. You can download it from my tips page or ADN. Download Scripts.zip.

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

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

Arnd,
can you correct my syatnx or tell me where excatly I'm doing mistake ..?
Hary

Har,

I am trying to see what your scheduler thinks it has, this is better than posting your command line. If you enter the at command without any options it will show you what is in the schedule and how it has interpreted your submissions.

try to make it interactive with desktop with "/interactive"

let me know what happens

regards
manoj

'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

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