Is it possible to invoke a script (*.vbs) from an SQL startup script

Question

I need to know if it is possible that when we start SQL some executable runs as well to start application services after SQL starts.The intention is to automate the process that when SQL starts , some application services starts as well (this is done thru a script with a vbs extension)..Please advise.. Thanks

Answer 1

You can run .VBS file as below from sql server.

Exec xp_cmdshell 'cscript C:\Filename.vbs'

You can write your script using Exec xp_cmdshell 'cscript C:\Filename.vbs' & create one store procedure.

Mark that store procedure as startup procedure. Now SQL server will execute this store procedure each time on start up.

---

Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

Answer 2

Thanks much Rohit..will try that!

Answer 3

Make sure that the script has no GUI elements (no windows, i.e., a pure console script) and requires no user input.

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 4

You could create a sqlagent job with a schedule that "Starts automatically when SQL Agent starts"

---

Thanks, Sethu Srinivasan [MSFT] SQL Server http://blogs.msdn.com/sqlagent -------------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.