run task at given interval

Hi.

I have a script that queries a sql database and sends html format mail to
correspondent department if there are new records.

But i would like that script to be run exactly every 30 minutes. I've tried
wscript.sleep but it seems that it waits until the called task ends, so it
gets a delay with every cicle.

Is there any other way to set a more precise timer that fires the task.?

.

Relevant Pages

  • RE: run task at given interval
    ... > I have a script that queries a sql database and sends html format mail to ... > correspondent department if there are new records. ... > But i would like that script to be run exactly every 30 minutes. ...
    (microsoft.public.windows.server.scripting)
  • Updated Question - Updating an SQL Database
    ... Using the script below I can only update the first record in ... Dim cnn As ADODB.Connection ... I have an Excel Spreadsheet that is populated from a SQL Database. ...
    (microsoft.public.excel.programming)
  • Problem with Large Query Returns from MS-SQL
    ... I am writing an application that is using DBI to access a MS SQL database ... Where where tableA is around 10 rows, then my test script returns all of the ... I put conditions on the query for the large table that would return only 2 ...
    (perl.dbi.users)
  • Trying to connect to SQL server
    ... I'm trying to use the script below to copy the event logs from our servers ... to a SQL database, but when I run the script it's trying to connect as null. ... Set colRetrievedEvents = objWMIService.ExecQuery _ ...
    (microsoft.public.windows.server.scripting)
  • SQL-DMO Service already running error
    ... I'm installing an app and it sets up an SQL database. ... SQL-DMO: An instance of this service is already running. ... I stopped the obvious services but then my app's script wouldn't work anymore (it needs SQL Server running, ...
    (microsoft.public.sqlserver.server)