MySQL Forums
Forum List  »  Events (Job Scheduler)

Dynamic event name
Posted by: Konrad Machlowski
Date: October 07, 2007 12:28PM

Hi ;)

I'm looking for a way, to create an event with dynamic name (with variable).
Like: CREATE EVENT variable

Why is that so important to me?
Well, i'm writing an application based on actions, and for specific action i need to 'Job Scheduler' do the action for me, and the best way (I think so) is to create event for every such an action.

As mentioned, i cannot use variable in name. I tried to create event "manually" by inserting a row into mysql.event, but it doesn't seem to be a good way >_>, I need to alter event by ALTER EVENT evtName, and only then it will be launched. But since I cannot use var in name, i cannot do this.

Is there any way, you recommend doing this?

Thanks in advance for answers,

Options: ReplyQuote

Written By
Dynamic event name
October 07, 2007 12:28PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.