DigiKnow: You can change the LASTRUN date from our SQL Console? In order to change the LAST RUN date of the Hach WIMS Interface, you will need to launch SQL Console and open it to OPSROOT. This is very dangerous and should only be done by Tier 2 and Tier 3 personnel who are extremely familiar with the OPS database structure. There is no audit trail of your actions and you are totally responsible for making changes to a customers database. Make sure you know what you are doing.

1. You will first need to know the INTERFACE_ID so run the following query: select * from g2_server

2. Next we look up the server run record to see what the LASTRUN date is: select * from g2_server_run where INTERFACE_ID = '52'

Notice in our example the LASTRUN date is 2/10/2009, and for this example we will say today is 2/10/2010 - a year later. You don't want the NT Service to import data for an entire year, import chunks of data manually. This is a trial and error case where you select a date range, like a couple days, and see how long it takes. If you think you can do a month in a reasonable time, go for it - but I would recommend keeping the range less than a few months.

3. To prevent the NT Service from importing data since last year, this LASTRUN must be changed. You can do this with the SQL command: update g2_server_run set LASTRUN = '2/10/2010' as shown below:

Now when we rerun the query in step 2 we get: