Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Posts
    240

    Unanswered: Running update syntax at set time

    Hi

    Is it possible for me to run an update syntax at a certain time say midnight for example?

    I'm trying to update a bit field in my table (which acts as a checkbox in my Access front end), but only if three date fields are before todays date. The dates in question are in two other tables.

    If so how would I go about doing this?

    Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Have you looked at Books OnLine and read about the SQL Server Agent and scheduled jobs?

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Sep 2005
    Posts
    240
    What's Books OnLine, and where can I find it?

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by KevCB226
    What's Books OnLine, and where can I find it?
    Books Online = BOL = SQL Server Help - easily accessed via Query Analyser and Enterprise Manager.

    BTW - are you sure you want to derive this overnight rather than at runtime or (possibly) at point of data capture?
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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