Scheduled dsexport.exe will not end

tbtcust · Post by **tbtcust** » Mon May 18, 2009 12:14 pm

I have scheduled a Sequence job that has an Execute Command Stage that runs the following command
dsexport.exe /H=999.99.99.9:9080 /U=DsAdmin /P=pwrd ProjectName C:\MyFolder\ProjectName.dsx

This job starts but never ends. The dsx file is created but no DataStage objects are sent to the output. DsAdmin is not my user id.

Does anyone know what could be going on?

Thanks in advance for any help

chulett · Post by **chulett** » Mon May 18, 2009 1:12 pm

Run it just like that from the cmd line.

tbtcust · Post by **tbtcust** » Wed May 20, 2009 6:43 am

Thanks chulett. I'm trying to schedule this to run off hours when no one is using DataStage. Do you think this is possible?

chulett · Post by **chulett** » Wed May 20, 2009 6:49 am

Yes. Did you try my suggestion? It wasn't meant as the solution, but rather to show you it won't run with your syntax and you need to fix it.

tbtcust · Post by **tbtcust** » Wed May 20, 2009 7:15 am

Apologies. I omitted the fully qualified path for dsexport.exe and forgot the DataStage server name. For clarity I changed ProjectName.dsx to DSexportOuptputFileName.dsx

D:\IBM\InformationServer\Clients\Classic\dsexport.exe /H=999.99.99.9:9080 /U=DsAdmin /P=pwrd DataStageServerName/ProjectName C:\MyFolder\DSexportOuptputFileName.dsx

chulett · Post by **chulett** » Wed May 20, 2009 9:14 am

And... does this actually work for you and give you the desired results from the command line? I'm asking because (unless it has changed in 8.x) that command will only export a single job not an entire project - you would use dscmdexport for the latter.

tbtcust · Post by **tbtcust** » Wed May 20, 2009 12:38 pm

Absolutely works for the whole project. I have been doing it at the command line for awhile now and just need to automate and schedule

I tried dscmdexport and it works at the command line but in a scheduled Sequence job I received a "failed to attach to project" message

chulett · Post by **chulett** » Wed May 20, 2009 1:34 pm

And I've used dscmdexport for years in a version of the batch file that Kim Duke has posted on his site. Interesting.

tbtcust · Post by **tbtcust** » Thu May 21, 2009 5:30 am

I'm sorry chulett. There is a key part I forgot to add to the original post. I am not signed on to IIS server when the job is started. It runs at 3 AM.

Any additional comments would be appreciated. Thanks.

chulett · Post by **chulett** » Thu May 21, 2009 5:38 am

Well... figured it must have something to do with 8.x over what I've seen (and see) in 7.x. Someone with more 8 experience would need to help, it seems, that or your official support provider.

cfuller · Post by **cfuller** » Thu May 21, 2009 8:38 pm

If your running in Ver 8, have you tried the 'istools' command shell provided with the client install, it may work a little better. I know I have had problems with scheduled exports and imports, and it seemed to have something to do with the account attached to the scheduled task. This tools may work a little better.

Just a thought.