Jump to content
  • 0

SQL Events not Running as Scheduled


OSUapoc

Question

For some reason, after moving to a new server, our SQL events no longer seem to be running as scheduled. Now, I've started the scheduler both via the command prompt in MySQL as well as verified that it is set to be ON in the my.ini for the database. Anyone have any other ideas/places for me to check to see why the events are not running? I've also verified, through posting the event function into a query, that the syntax is good for the event.

Any restriction on how close to a restart you can run an event? The restart was to occur at 12, with the event running at 12:01:15. Does the server lock the tables at all during a restart?

Thanks for the help!

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Advertisement
  • Discord

×
×
  • Create New...