Wednesday, June 1, 2011

Run a VBscript using SQL Server.

Today I came across a question in EE of how to run a VBscript using SQL server.
Well, it could be done using the SQL server agent or using SSIS, but the easiest way would be the SQL agent.

Here how:

1-Right click on "SQL Server Agent" and select "New Job"
2-Name the job according to your needs.
3-From the "Steps" , select New.
4-Name it to your needs and select the "Type" as "Operating System CmdExec" as shown in the screenshot.
4-Set the schedule as desired and that's it!!