dbTalk Databases Forums  

running a vbs file as a step of an SqlServer job

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss running a vbs file as a step of an SqlServer job in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Greenberg
 
Posts: n/a

Default running a vbs file as a step of an SqlServer job - 12-11-2007 , 06:19 AM






Hi
I have a VBScript file which runs fine when I click it or when I run it
from a command prompt level.
I added it as the 1st step of an SqlServer job and the job always fails
with the error message
"Executed as user: GVIANT\Administrator. The process could not be
created for step 1 of job 0xBE3A0405EB9F624282C1A9474AA9F719 (reason: %1
is not a valid Win32 application). The step failed."

Cn anyone help me understanding this error message.

Thanks 1

David Greenberg

Reply With Quote
  #2  
Old   
scoots987
 
Posts: n/a

Default Re: running a vbs file as a step of an SqlServer job - 12-11-2007 , 06:55 AM






On Dec 11, 6:19 am, David Greenberg <davi... (AT) iba (DOT) org.il> wrote:
Quote:
Hi
I have a VBScript file which runs fine when I click it or when I run it
from a command prompt level.
I added it as the 1st step of an SqlServer job and the job always fails
with the error message
"Executed as user: GVIANT\Administrator. The process could not be
created for step 1 of job 0xBE3A0405EB9F624282C1A9474AA9F719 (reason: %1
is not a valid Win32 application). The step failed."

Cn anyone help me understanding this error message.

Thanks 1

David Greenberg
Do you have VBScripting enabled on the server? Without more info I
couldn't guess at anything else. Versions? Windows 98? ;-)



Reply With Quote
  #3  
Old   
David Greenberg
 
Posts: n/a

Default Re: running a vbs file as a step of an SqlServer job - 12-11-2007 , 08:01 AM



scoots987 wrote:
Quote:
On Dec 11, 6:19 am, David Greenberg <davi... (AT) iba (DOT) org.il> wrote:

Hi
I have a VBScript file which runs fine when I click it or when I run it
from a command prompt level.
I added it as the 1st step of an SqlServer job and the job always fails
with the error message
"Executed as user: GVIANT\Administrator. The process could not be
created for step 1 of job 0xBE3A0405EB9F624282C1A9474AA9F719 (reason: %1
is not a valid Win32 application). The step failed."

Cn anyone help me understanding this error message.

Thanks 1

David Greenberg


Do you have VBScripting enabled on the server? Without more info I
couldn't guess at anything else. Versions? Windows 98? ;-)

We have windows 2000 on the server.
I am sure we have VBScripting enabled on the server because the job runs
fine when I click it to run it or when I run it from the command prompt.
We use SqlServer 2000.


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.