Questions tagged [event]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
21 views

MySQL event scheduler — Event running at wrong time

I have created a event to run EVERY 1 DAY at 3:15 (am). I know that timezones affects events and actually I create a query to check the START time in mysql.event (GMT timezone) and information_schema....
-2
votes
1answer
46 views

SQL Server Event Log Summary [closed]

I want to generate a daily summary of SQL Server Event Logs which will be sent via email. I have currently been able to set up SQL email alerts for error logs,but they are sent individualy when an ...
0
votes
1answer
91 views

HKEngineEventFile at Log folder of SQL Server

There were inconsistency issue in our database as asked in this question. Same is fixed now and database is running without any issue. I noticed that SQL service was rebooted many times in last 3 ...
0
votes
0answers
24 views

Mysql 8 event scheduler timezone

im a bit confused about the event scheduler. First off, it is running and working, but the timezone handling confuses me a bit, as it seems it's not what is documented on events metadata So to start ...
0
votes
0answers
61 views

Do Hive Materialized Views respond to added partitions to source tables?

Hive Materialized Views support partitions, CREATE MATERIALIZED VIEW [IF NOT EXISTS] [db_name.]materialized_view_name [DISABLE REWRITE] [COMMENT materialized_view_comment] [PARTITIONED ON (...
0
votes
1answer
60 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
309 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
34 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
592 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
261 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
280 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
1k 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
593 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
65 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
515 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
117 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
24 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 ...
4
votes
1answer
21k 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
638 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
151 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
40k 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
26k 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
18k 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 ...
1
vote
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 ...