How do I schedule a "non-SQL" vbscript for execution

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Larry Woods (larry_at_NOSPAMlwoods.com)
Date: 05/01/04 

Date: Sat, 1 May 2004 08:47:37 -0700

Hi,

I want to take advantage of the SQL Server Scheduler to execute a script
that will manipulate some tables in a database, send an email, etc.
Possibly execute an ASP script.

Is this a problem with the scheduler?

TIA,

Larry Woods

Relevant Pages

  • Executing Informix dbaccess in a Windows background environment
    ... Our main objective is to execute an Informix stored procedure that will ... to create an sql script file each day, and to execute it using dbaccess. ... connecting to the database server. ...
    (comp.databases.informix)
  • Re: script "chaining"
    ... If a task would take too long to run while attached to the browser, the current system writes the data to a database file. ... The daemon checks that file every 10 seconds and executes the task, writing the data back to database. ... If you take the A out of LAMP you can write a php script like a bash script or a perl script and execute it. ...
    (comp.lang.php)
  • Re: File upload permissions
    ... The database is for agendas, minutes and audio of various city meetings. ... The script then updates the database. ... You say, the "and run it" part isn't true if it's not inside the document tree (and if it is inside the document tree, that's incredibly ... If your webserver is set up correctly, it won't execute .txt, .pdf, etc. files. ...
    (comp.lang.php)
  • Re: Permission denied
    ... This script is a little different that others ... I've written in that it inserts records into a database table. ... the error above when I execute it on a server. ... permissions. ...
    (microsoft.public.windows.server.scripting)
  • Re: what word will stop everything after it in a SQL script?
    ... That will only work if your entire script does not have a GO statement ... > Need smaller SQL2K backup files? ... >> Suddenly it wants to execute everything on the screen. ... >> and I don't want to specify a real database name. ...
    (microsoft.public.sqlserver.programming)