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. 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.?
- 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. ...
- 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. ...
- 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 ...
- 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 _ ...
- 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, ...