Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Unanswered: Create automatic updates for tables

    Hi this is my issue, I have created a database "The Matrix", using ODBC links to extract data from an oracle based system using macros, this information is then stored in various tables. linked to "The Matrix" are several other databases (frontend users), carrying out various analytical reports on the data stored. Due to the rising demand of reports, what I need to do is update all the data tables, before the front end users start work, unfortunatly due backups taking place during the night, I can not leave "The Matrix" open for the automated macros to activate and update all the required tables. Therefore folkes, is there anyway I can create something that will automatically launch the "The Matrix", wether it be built internaly within "The Matrix" D/B or some external programme.

    Thanks in advance

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    Windows Scheduler ??

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Sep 2004
    Posts
    2
    Quote Originally Posted by izyrider
    Windows Scheduler ??

    izy

    A big Thankyou izyrider, completly forgot about windows scheduler, problem solved

    Cheers Dangermouse

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •