Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 use exe application from job

Author  Topic 

casati74
Posting Yak Master

109 Posts

Posted - 2006-09-19 : 08:45:42
Hello,
i have created a job to lunch stored procedure; now i want lunch a exec file from the same job... how can i do it?????


es

job1

exec doReplication
exec c:\myexec

thank's


SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-19 : 08:49:49
Before I even try to understand your problem, how did we help you with this topic
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72127

You could at least have the courtesy to inform us if our help (which is plenty from many persons) is useful to you.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

casati74
Posting Yak Master

109 Posts

Posted - 2006-09-19 : 08:53:04

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72127
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-19 : 09:01:24
You can write the two statements in the Command Textbox.
But I doubt "exec c:\myexec" will be valid though.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

casati74
Posting Yak Master

109 Posts

Posted - 2006-09-19 : 09:13:33
in fact my problem is
exec c:\myexec

Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-19 : 09:22:30
You want to execute a directory?
What is your objective with that row?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

casati74
Posting Yak Master

109 Posts

Posted - 2006-09-19 : 09:26:34
i want run a .exe file to send an e-mail.

i can't use a sp_sendmail
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-19 : 09:28:14
exec xp_cmdshell "c:\mydir\myapp.exe"


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

casati74
Posting Yak Master

109 Posts

Posted - 2006-09-19 : 09:36:00
now i try it thank's
Go to Top of Page
   

- Advertisement -