Questions tagged [event]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
35 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
10 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
11 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
48 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
289 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
534 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
249 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
260 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
937 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
557 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
62 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
497 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
115 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 ...
3
votes
1answer
20k 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
626 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
39k 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
25k 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
17k 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 ...