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 ... :)
Showing posts with label t-sql. Show all posts
Showing posts with label t-sql. Show all posts
Tuesday, March 27, 2012
Wednesday, February 15, 2012
editor + VS 2005 ?
Hey
What tool for T-SQL with Intellisense and other nice stuff will you
recommend ? Preferably to use as add-on for VS 2005 but not as a must.
JarodHere is one and it's free (as in beer) until September 2006 so If you
like it, you can purchase it (or not)
SQL Prompt by Red Gate
http://www.red-gate.com/products/SQL_Prompt/index.htm
Denis the SQL Menace
http://sqlservercode.blogspot.com/
What tool for T-SQL with Intellisense and other nice stuff will you
recommend ? Preferably to use as add-on for VS 2005 but not as a must.
JarodHere is one and it's free (as in beer) until September 2006 so If you
like it, you can purchase it (or not)
SQL Prompt by Red Gate
http://www.red-gate.com/products/SQL_Prompt/index.htm
Denis the SQL Menace
http://sqlservercode.blogspot.com/
Labels:
add-on,
database,
editor,
heywhat,
intellisense,
microsoft,
mysql,
oracle,
preferably,
server,
sql,
stuff,
t-sql,
tool,
yourecommend
Editing SQL Jobs
I have scheduled a T-SQL job that runs every morning using Enterprise Manager. Now I want to change the SELECT and UPDATE statements that this job runs, but I can't find anywhere to edit a job that has already been scheduled. Any help would be appreciated.
ThanksIn Enterprise Manager, under your SQL Server
-- expand the Management node
-- expand the SQL Server Agent node
-- click on Jobs
-- right-click on your job and choose Properties
-- click on the Steps tab
-- click on the desired Step and choose Edit...
Terri
Subscribe to:
Posts (Atom)