Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [event]

The tag has no usage guidance.

0
votes
1answer
40 views

MySQL schedular every day in a time periode every hour

This schedular i made doesn't work how i would like it to work. The idea is that it will run every day in a time periode from 06:15:00 till 23:59:59 and in that only periode run every hour That ...
0
votes
1answer
264 views

Generate Script for Event Notification

I need to migrate my Event Notifications from current server to another one. I would like to generate that code, but I couldn't find an way to do that. Try 1 I have tried reverse engineering from ...
-1
votes
1answer
34 views

If true then insert event [closed]

I have an insert statement that inserts events into a table. I need it to NOT insert if these events contain specific words or even specific username executing the event. Thought this would be easy ...
1
vote
1answer
32 views

event get not executed

I'm on 2 debian8 box's with mysql-5.7.19. I have a master slave replication running, replicating one db (db1.1) from master to slave (db2.1). Replicated db's on master and slave have same names. ...
-1
votes
1answer
496 views

Troubleshooting ORA-12012, ORA-02194 and ORA-06512 errors

On one of installations I see the following errors during job execution: alert.log: Wed Aug 16 16:57:27 2017 Errors in file c:\oracle\product\10.2.0\admin\db\bdump\db_j009_3868.trc: ...
1
vote
0answers
226 views

Postgres upsert perform multiple actions _OR_ versioning of events in an “append only” store

Background I am running on postgres 9.5 I have a table with events (in theory, it is, currently, an append only store). Certain event types can appear only once on a given date. (So currently, we ...
1
vote
2answers
247 views

DDL-trigger for ALTER_AUTHORIZATION

I need to perform some audit, when change of a securable ownership, such as ALTER AUTHORIZATION ON SCHEMA::[SchemaName] TO [PrincipalName]; happens in database. Database scope DDL-trigger seems an ...
3
votes
2answers
866 views

Does not writing a checkpoint record damage anything?

I got an alert Event ID: 3619. Could not write a checkpoint record in database 'ID ####' because the log is out of space I know why it happened, I have addressed the issue, backed up the t-logs, ...
0
votes
0answers
526 views

SQL server Log shipping Copying failed due to incorrect username and password

I have 2 sql server 2008 servers with log shipping. Now im trying to add one more secondary server to the existing log shipping. While copying the log files to secondary I got the below error on SQL ...
0
votes
1answer
57 views

MySQL 5.6 events are created disabled and they don't run

I am using the normal syntax to create an event, but they are created disabled and they never run: create event p1 on schedule at now() on completion preserve enable do call proc1(); I added enable ...
0
votes
1answer
474 views

MySQL Event Help - Update column value for each row every 15 minutes

Okay so if I have a login database: id | email | pass | attempts ---------------------------- 1 | "" | "" | 4 2 | "" | "" | 2 Attempts marks the number of attempts made at logging ...
1
vote
0answers
112 views

MySQL Event scheduler not generating CSV

The scheduler seems to be running from INFORMATION_SCHEMA.EVENTS but there is no CSV output. The event scheduler has to automatically produce a csv to pass on the data to another system. It's like ...
0
votes
1answer
23 views

How to name a new table storing location at which transaction occurred [closed]

My client wants to begin collecting data about where transactions occurred. We have a list of their events and locations where payments might be received, I'm just stumped on what to call the table ...
3
votes
1answer
19k views

How to turn Event Scheduler On permanently in MySQL?

How do I turn on the event scheduler in mysqld permanently? I'm using phpMyAdmin and I have scheduled an event to copy records from one table to another everyday at a specific time, but the records ...
1
vote
0answers
612 views

MySQL event scheduler doesn't work

I have the following MySQL event sheduler to udpate some values in RECETAS table's ESTADO column. I want to run it everyday at 10:05:00. CREATE EVENT IF NOT EXISTS actualizar_prueba ON SCHEDULE ...
1
vote
1answer
149 views

How to update MySQL data within intranet from MySQL data in cloud?

I am currently using a MySQL DB located within the intranet. Only the people within the LAN can access the information. I'm trying to re-create the MySQL DB in a cloud provider. This can be accessed ...
11
votes
1answer
37k views

Scheduling an event every day at a given time

I want my event to run everyday at 00:20. I am confused in scheduling of the time. Should I be using the first option or the second one? Option 1 CREATE EVENT my_event ON SCHEDULE EVERY 1 DAY ...
3
votes
1answer
24k views

column auto updated after 24 hours in mysql

i have a table T1 with column : Name State time mon 1 2014-01-09 11:23:00 tue 0 2014-01-07 14:40:00 wed 2 2014-01-08 09:23:00 thu ...
4
votes
1answer
16k views

Where EVENTS history are logged/recorded in MySql?

I just setup some stored procedures to run in the event scheduler using CREATE EVENT. I'm trying to find where (if somewhere) the history of it running is stored. I looked at the docs but couldn't ...
0
votes
1answer
7k views

Seting timezone per database in MySQL

I wanted to know if MySQL let the admin set a timezone per database ? I have three different databases for three different customers. Each of them being in their own timezone. I would like to load ...