SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2002
    Posts
    96
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cron Job with MySQL...

    I need instructions on how to create a CRON job that will do the following every week/sunday...

    Part1. run a SQL command to spool results to a unique filename

    Part2. run a SQL command to update a TARGET table

    The updatewill be based on a Select statement of the SOURCE table and the results will be grouped by a running counter...

    Plus the SOURCE table will have an update to reset a column value after the update is down...

    result table:
    Counter, result1
    Counter, result2

  2. #2
    He's No Good To Me Dead silver trophybronze trophy stymiee's Avatar
    Join Date
    Feb 2003
    Location
    Slave I
    Posts
    23,424
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)
    That's a Perl question ( or whatever you prefer to run your cron jobs in). Just write a script that connects to the database and runs those sql commands. If you provided the actual sql statements to be run, I'm sure someone can write one for you pretty easily.


Bookmarks

Posting Permissions

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