how to run .exe from job scheduling

Question

Post reply

how to run .exe from job scheduling

Alok Nand

SSC Enthusiast

Points: 174
More actions
November 15, 2006 at 12:23 am

#116334

hi,
i have tried invoke one .exe through sql server 2000-->Sqlserver agent -> jobs by selecting (type - operating system command) cmdEXEC [execute "C:\Project.exe"] but nothing happens at due schedule time.
Please let me know the solution... thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32342 More actions · Answer 1

Have you tried

execute master.dbo.xp_cmdshell 'c:\project.exe'?

Alok Nand SSC Enthusiast Points: 174 More actions · Answer 2

already tried it... getting the same status...

is it possible to invoke .exe from job scheduling in sql server 2000...??????

Luke L SSC-Dedicated Points: 35547 More actions · Answer 3

Can you give a bit more detail on what is supposed to happen when you execute Project.exe? Are you expecting a return back, or is this just taking an action on your database etc...

Are you getting any error messages?

Check permissions on Project.exe.

Check task manager and make sure it's not running, it may be hung waiting for somethign from you.

For a test, try putting it in a .bat file and redirect the output to a text file, to make sure at least that much is happening.... somethign like.

echo start project.exe >> c:\mytest.txt

c:\project.exe >> c:\mytest.txt

echo end project.exe >> c:\mytest.txt

Then have your task call the .bat file instead. this will verify that you can actually call operating system commands and now you just need to look at why things are or aren't retuirnign the results you expect.

To help us help you read this[/url]For better help with performance problems please read this[/url]

sindhigrl Default port Points: 1448 More actions · Answer 4

Have you tried selecting (type - operating system command) cmdEXEC and in the command window put just "C:\Project.exe" ? I think that might work.

Thanks!

Alok Nand SSC Enthusiast Points: 174 More actions · Answer 5

Hi,

i tried it (type - operating system command) cmdEXEC and in the command window put just "C:\Project.exe").. but it doesn't work too.

let me know if u hav any alternative soln... thanks, Alok.

Sergiy SSC Guru Points: 110208 More actions · Answer 6

What happens when you run

execute master.dbo.xp_cmdshell 'dir c:\'

Is file "project.exe" in the list returned?

_____________
Code for TallyGenerator

Alok Nand SSC Enthusiast Points: 174 More actions · Answer 7

ya .. run it. got the following return.. at sql query analyzer but nothing returns through job scheduling

Volume in drive C has no label.

Volume Serial Number is 444E-55FB

NULL

Directory of c:

NULL

11/13/2006 04:33p 16,384 Project.exe

1 File(s) 16,384 bytes

0 Dir(s) 13,967,835,136 bytes free

NULL

Sergiy SSC Guru Points: 110208 More actions · Answer 8

Does your C:\Project.exe actually work?

What are the conditions when C:\Project.exe does the job?

_____________
Code for TallyGenerator