There are several ways how this can be done. Here is the most straightforward:
If you don't have a database connection already configured, configure it using Tools/Database profiles menu.
Create a new database job, for the SQL property enter EXECUTE dbo.myproc(...) or CALL myproc(...) or whatever valid syntax for your database is.
In the job "on finish" notification action select "Run program" "Run script". In the first case enter on the next step enter name of your VBS file, in the second case on the next step select VBS as the script language and copy and paste your VBS file, insert Sum Main() as the first line, insert End Sub as the last line.
That's it. : I know there is scripts that will execute database commands. I am having a
: little trouble. : This is what I need to do. : 1) Connect to a Database and Execute a stored procedure.
: 2) Once this stored procedure is completed (that is important) have the JAL
: execute a .VBS script. : Thanks for yoru help. :-)
|
