Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Jul 2002
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Firing off SQL via Cron

    A newbie here...

    Can anyone point me to the basics of how firing off a sql statement can be done automatically by CRON on a unix box?

    Essentially I want to have a sql sript that clears daily totals in a table every night at 00:01 am -- I understand the script part... but I don't know HOW that happens with Cron

    Thanks...
    Fritz Jung
    co-founder
    the Witches' Voice
    www.witchvox.com

  • #2
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,273
    Thanks
    4
    Thanked 83 Times in 82 Posts
    You can write an sql script then run it using crontab:

    http://www.dbaoncall.net/references/ht_use_crontab.html
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster


  •  

    Posting Permissions

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