scheduling jobs

[Srinviasa Biruda]

Hai Good Evening all,

I'm doing a small work. I need to connect the server database from the local database with in a particular timeperiod.

For example:
In Round Robin algorithm 10 systems are there in the queue. and every system has a some particular time stamp like 10 seconds. then in that 10 seconds every system has to do the job in that particular time period.

Like that I need to create a trigger so that either when the internet is off or on.

Please help me to go further.

This is the following code for the MySQL server database.

import MySQLdb
import _mysql_exceptions as DB_EXC
cxn = MySQLdb.connect(host='localhost',db='srinu')
cur = cxn.cursor()

cur.execute(('create or replace trigger test1 before update on emp1
for each row update emp1 set name=%s where id=%s'),(name1,id1)
)

cur.execute('create or replace event a on schedule every 2 second do
update emp1 set name=%s where id=%s',(name1,id1))

cur.close()
cxn.commit()
cxn.close()

Here test1 is the trigger name, emp1 is the table name.

Please help me to go further.

Thank You for helping me in advance.

Warm Regards,

Srinivas