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.
| Author |
Topic |
|
getur.srikanth@gmail.com
Yak Posting Veteran
77 Posts |
 Posted - 2009-10-05 : 17:41:00
|
| I have .net exe on remote server. How can I run this exe in SQL as job? any tutorial. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-10-05 : 17:47:25
|
| Why does it need to run from a SQL job? Can it be set up as a scheduled task on the server itself? |
 |
|
|
getur.srikanth@gmail.com
Yak Posting Veteran
77 Posts |
Posted - 2009-10-05 : 17:58:29
|
| step1: is Stored proc runstep2: is .net exe run.in step1 i will get data from different source to SQL. from the step2 will take care of. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-10-05 : 19:52:37
|
| It's probably easier to create a scheduled task on the remote server to run a batch file which contains:1) A sqlcmd utility call to run the stored procedure on the SQL Server2) A call to the .Net EXE on that serverSQL Server's job system is not well suited for running remote EXE's. |
|
|
|
|
|
|
Run .net exe from SQL.