SySQL Scheduler

[kaperucito]

Sup. I had a friend request about a program that do this, so I decided to make a fast one. Took me 3h for code this.

Basically, with this program you can run an stored procedure or a query on your database every x miliseconds. You can run multiple instances of this program so you can run more than one query with different times.

Pics:

Download:

To view the content, you need to sign in or register

Virustotal:

To view the content, you need to sign in or register

Source:

To view the content, you need to sign in or register

Fill the config.ini file with your database data before starting the program. Select the DB you want to use for execute the query, both if you execute a query or an stored procedure.

If you find any bug let me know. I won't update this program, but will fix the bugs that people find.

Enjoy =3

 

[Zedge]

Tranks

 

[Statiic]

wow nice thanks!

 

[Kira]

i wanna Query if any one know to made it xD

Give silk for online player any help

Like it

 

[romio10]

good jop man

 

[arabianfox]

very helpful really.thank you for sharing this.If you don't mind can you add option to execute query or SP at Specific time Like everyday at 12:30 am for example..

Thank you

 

[kaperucito]

very helpful really.thank you for sharing this.If you don't mind can you add option to execute query or SP at Specific time Like everyday at 12:30 am for example..

Thank you

Sorry I won't be adding more features to this program, but anyway with the current program you can kinda do it. Make a query that runs every minute, and check on the query itself what hour it is, with "SELECT CURRENT_TIMESTAMP", it should return the current date/hour in this format: 2012-08-22 19:23:49.890
With that, you can make your query check what hour it is right now, and if it match the hour you want, execute an specific action.

 

[NourAyman]

Very nice , keep it up dude

but what should i do if i want to execute a query every day , what should i wright in delay ms ?

 

[kaperucito]

Very nice , keep it up dude

but what should i do if i want to execute a query every day , what should i wright in delay ms ?

To view the content, you need to sign in or register

24h are 86400000 ms, set that on the delay and it will run every 24h.

 

[NourAyman]

thank you :

 

[chinowyc]

Great job Thanks!!

 

[kaperucito]

Added source code:

To view the content, you need to sign in or register

(sorry I usually don't comment the code a lot, bad behavior I know D

 

[Caosfox]

lol @ "tetas,4"

Good job man