Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    14

    Question Unanswered: Batch Jobs in MySQL

    Dear Friends,

    What is the equivalent of oracle jobs in MySQL?

    I have a requirement in which the data in selected tables will be archived and moved to other tables. For this purpose I had created a stored procedure that will do the work for me.

    Now the question is - how to schedule to run this stored procedure every week (say on friday night at 8 PM) automatically.

    Thanks in advance.

  2. #2
    Join Date
    Apr 2005
    Location
    Baltimore, MD
    Posts
    297
    I believe you need to write a cron job to call that stored procedure in batch mode. I'm pretty sure MySQL does not the capability to schedule jobs.

Posting Permissions

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