MySql Event Scheduler. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

MySql Event Scheduler.

Author

Topic

Gerald30
Yak Posting Veteran

62 Posts

Posted - 2012-03-15 : 23:30:45

Good Day.

Can you please help me out.

I have created a job scheduler for MySql but it doesn't work.

Kindly check my code and please tell me if I have missed something.

DELIMITER $$
CREATE
EVENT testevent
ON SCHEDULE EVERY 5 minute STARTS '2012-03-16 11:17:00'
DO BEGIN

update l_bbd_001
set bbd_ng_qty = bbd_inp_qty - bbd_out_qty
where bbd_bbn = bbd_bbn;

END

This Job should update the bbd_ng_qty base on the input - output of the 2 columns.

Thanks in advance.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-03-15 : 23:33:35

please post in MySQL forum. SQLTeam.com is on Microsoft SQL Server

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources