Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Use SQL Job to launch an EXE

Status
Not open for further replies.

Brit

Programmer
May 15, 2001
15
US
I have a nightly SQL job that loads data into several tables. I also have an executable that runs stored procedures and manipulates the data on several databases across several servers. I would like for the executable to be run immediately after the SQL job. Is there a way to have the job launch the executable?

Any help is appreciated.
 
SQL 7 , but I already found the answer.

If you classify the step as an Operating System command then all you have to do is put the path to the exe file in the step.

It appears to work well. Now I just have to make sure all my permissions are correct.

thanks for the response.

Brit
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top