Dscmdexport via Task Scheduler

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Wasn't talking about the Windows scheduler or what user it uses to run the task but rather something you probably need to add to the dscmdexport command line:

dscmdexport /H=%Host% /U=%User% /P=%Password% /D=????
-craig

"You can never have too many knives" -- Logan Nine Fingers
brownnt
Premium Member
Premium Member
Posts: 21
Joined: Tue Feb 03, 2009 6:07 pm

Post by brownnt »

chulett wrote:Wasn't talking about the Windows scheduler or what user it uses to run the task but rather something you probably need to add to the dscmdexport command line:

dscmdexport /H=%Host% /U=%User% /P=%Password% /D=????
I tried to add the /D command, but it gave me the error below:

dscmdexport aborted:
Failed to attach to the project
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

And you are certain you used the correct value? Unfortunately, I've got nothing else to add except to suggest contacting your official support provider for help.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I know they're not supposed to be positional, but try it with the domain switch first. For example:

Code: Select all

dscmdexport  /D=%Domain% /U=%User% /P=%Password% /H=%Server% %ProjectName%
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
PhilHibbs
Premium Member
Premium Member
Posts: 1044
Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:

Post by PhilHibbs »

brownnt wrote:I tried to add the /D command, but it gave me the error below:

dscmdexport aborted:
Failed to attach to the project
And you say that exactly the same batch works fine when you run it manually?
Phil Hibbs | Capgemini
Technical Consultant
brownnt
Premium Member
Premium Member
Posts: 21
Joined: Tue Feb 03, 2009 6:07 pm

Post by brownnt »

ray.wurlod wrote:I know they're not supposed to be positional, but try it with the domain switch first. For example:

Code: Select all

dscmdexport  /D=%Domain% /U=%User% /P=%Password% /H=%Server% %ProjectName%
Thanks, but I tried it that way.
brownnt
Premium Member
Premium Member
Posts: 21
Joined: Tue Feb 03, 2009 6:07 pm

Post by brownnt »

PhilHibbs wrote:
brownnt wrote:I tried to add the /D command, but it gave me the error below:

dscmdexport aborted:
Failed to attach to the project
And you say that exactly the same batch works fine when you run it manually?
Yes, sir. Run just fine when I kick off the batch file manually via command line. Will not run via windows task scheduler.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can you have the scheduler script ECHO the command so you know exactly how the variables are being passed?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

brownnt wrote:
chulett wrote:Wasn't talking about the Windows scheduler or what user it uses to run the task but rather something you probably need to add to the dscmdexport command line:

dscmdexport /H=%Host% /U=%User% /P=%Password% /D=????
I tried to add the /D command, but it gave me the error below:

dscmdexport aborted:
Failed to attach to the project
I just encountered the same issue. I tried /O it did not complain but did not work. I tried /NODEPENDENTS which also did not work. These all did not bring up a dialog box. When I ran under cmd directly then I get a dialog box when I leave off /O and /NODEPENDENTS. If all I do is reselect the project it outputs a DSX file. Not cool. Need a patch.
Mamu Kim
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Does the box just ask for a default (e.g. OK) response? If so you can try the old trick of redirecting stdin from /dev/null (or .\NUL).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

No, it shows the login screen.
Mamu Kim
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That suggests that the username/password in the command is incorrect, or that the login/security service (in the services tier - the machine where WAS is installed) is not running/inaccessible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

All you have to do is select a project, so user and password are correct.
Mamu Kim
Post Reply