Embed VBS or Call VBS from Job Script

How do you call an external VBS script from within a T-SQL Job?
At the end of a job I want a VBS to fire off in the last step.
Not sure how to do this. Looked everywhere ... :)Typically, T-SQL (Execute SQL Task) and VBS (ActiveX Script Task) are
included in a DTS Package, which is then scheduled for execution using a
job.
http://msdn.microsoft.com/library/d... />
x_06er.asp
"Whispering Leaf" <WhisperingLeaf@.discussions.microsoft.com> wrote in
message news:63FFAF27-72B1-45B6-A326-5DCDFED2735A@.microsoft.com...
> How do you call an external VBS script from within a T-SQL Job?
> At the end of a job I want a VBS to fire off in the last step.
> Not sure how to do this. Looked everywhere ... :)

Email Functionality from SQl 2005

I am fairly new to MS SQL and an wondering if the following is possible;

Step 1 - person fills out a form on our website and submits it to our SQL DB via a stored procedure

Step 2 - the stored procedure inserts some of this information into a DB table and sends some of the information via the inbuild DBMail in an email.

Firstly, is this possible?

Sencondly, is there a way of encrypting this email before it is sent?

"Firstly, is this possible?"

Sure, look in the BOl for sp_send_dbmail for more information.

"Sencondly, is there a way of encrypting this email before it is sent?"

What do you mean by that ? AFAIK S/MIME or another technique isn′t available for sending mails via SQL Server.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de