MySQL Bugs: #15027: Task, Job, Stored Procedure Scheduler

Bug #15027	Task, Job, Stored Procedure Scheduler
Submitted:	17 Nov 2005 17:00	Modified:	21 Nov 2005 14:20
Reporter:	Keith Blackwell	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	5.0	OS:	Windows (Win32)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Currently, external means must be used to execute Stored Procedures, or Tasks, or Jobs within MySql.  This requires a 2nd application layer.  An internal scheduler would eliminate this 2nd layer.

How to repeat:
try to make MySql do something at a specific time

Suggested fix:
A task/job/SP scheduler would be good.  Ideally, it would be able to create jobs, store them somewhere, and execute them at any specified day, date, time, and perform specified actions upon completion or failure; i.e., log, execute another procedure, send alert, etc.

This is work an progress (and already submitted as http://bugs.mysql.com/bug.php?id=6771)