dbTalk Databases Forums  

Schedule Error CmdExec

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Schedule Error CmdExec in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Flora Pho
 
Posts: n/a

Default Schedule Error CmdExec - 05-06-2005 , 07:08 AM






Hi,

I schedule a DTS package that runs manually, it's executed on the server
The owner of the package is Admin
The owner of the task is also Admin
And Admin is owner of the DataBase group
But the schedule task returns me the error:
"cannot be run because the CmdExec subsystem failed to load. The job has
been suspended"

How can i solve this problem ?
And how can i re-run the suspended task ?

Rgds
Flora.



Reply With Quote
  #2  
Old   
Helge C. Rutz
 
Posts: n/a

Default Re: Schedule Error CmdExec - 05-06-2005 , 08:42 AM






Hi Flora,

"Flora Pho" <FloraPho (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
newsB4D5ABA-690E-47C8-9178-44CBD0937195 (AT) microsoft (DOT) com...
Quote:
Hi,

I schedule a DTS package that runs manually, it's executed on the server
The owner of the package is Admin
The owner of the task is also Admin
And Admin is owner of the DataBase group
But the schedule task returns me the error:
"cannot be run because the CmdExec subsystem failed to load. The job has
been suspended"
because the normal errors caused by misconfiguration or security related
issues are very specific reported, saying exactly whats wrong, I think this
goes more to the dll hell direction.
Running the Task manually in Designer is something totally different, as
long as you run the designer on a different machine.
Is Admin also member of the sysadmin role, or did you configured the proxy
account?
Have you ever used CmdExec before? Have you changed anything, apllied SPs
or something like that?
What OS do you use for the Server?

Helge




Reply With Quote
  #3  
Old   
Helge C. Rutz
 
Posts: n/a

Default Re: Schedule Error CmdExec - 05-06-2005 , 08:55 AM



Hi Flora,

"Helge C. Rutz" <news050424 (AT) nurfuerspam (DOT) de> schrieb im Newsbeitrag
news:3e1ai7FmorrU1 (AT) individual (DOT) net...
Quote:
because the normal errors caused by misconfiguration or security related
issues are very specific reported, saying exactly whats wrong, I think
this goes more to the dll hell direction.
maybee this article is a hint?
http://support.microsoft.com/default...b;en-us;315005

Helge




Reply With Quote
  #4  
Old   
Flora Pho
 
Posts: n/a

Default Re: Schedule Error CmdExec - 05-09-2005 , 04:31 AM



I checked for the dll direction and it's ok
But i never use CmdExec before
How does it be configure ?

"Helge C. Rutz" wrote:

Quote:
Hi Flora,

"Helge C. Rutz" <news050424 (AT) nurfuerspam (DOT) de> schrieb im Newsbeitrag
news:3e1ai7FmorrU1 (AT) individual (DOT) net...
because the normal errors caused by misconfiguration or security related
issues are very specific reported, saying exactly whats wrong, I think
this goes more to the dll hell direction.

maybee this article is a hint?
http://support.microsoft.com/default...b;en-us;315005

Helge




Reply With Quote
  #5  
Old   
Jim Vierra
 
Posts: n/a

Default Re: Schedule Error CmdExec - 05-09-2005 , 10:40 AM



Here is the latest MDAC component checker. It reports on the version and
installation status of all versions of MDAC.

http://www.microsoft.com/downloads/d...displaylang=en


--
Jim Vierra

"Flora Pho" <FloraPho (AT) discussions (DOT) microsoft.com> wrote

Quote:
I checked for the dll direction and it's ok
But i never use CmdExec before
How does it be configure ?

"Helge C. Rutz" wrote:

Hi Flora,

"Helge C. Rutz" <news050424 (AT) nurfuerspam (DOT) de> schrieb im Newsbeitrag
news:3e1ai7FmorrU1 (AT) individual (DOT) net...
because the normal errors caused by misconfiguration or security
related
issues are very specific reported, saying exactly whats wrong, I think
this goes more to the dll hell direction.

maybee this article is a hint?
http://support.microsoft.com/default...b;en-us;315005

Helge






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.