Questions tagged [cron]
The cron tag has no usage guidance.
33
questions
0
votes
2
answers
1k
views
PostgeSQL Schedule Jobs
I am looking a way that can give the ability to schedule jobs on PostgreSQL, for example to schedule execution of some procedures or statements based on interval or on specific schedule.
I tried ...
- 170
1
vote
0
answers
539
views
Refresh materialized view on Postgresql 11 on RDS
We are currently on Postgres 11.13 on AWS RDS. I am trying to create a materialized view that takes about 6-7 minutes to run. What is the best way to keep this MV mostly up to date? I was thinking of ...
- 111
3
votes
2
answers
249
views
mysql backup password without root home
What's the best way to provide a MySql root password (~/.my.cnf) to cron job without root to have the home folder?
the server I'm using is centos
- 47
1
vote
0
answers
49
views
Replicating/Inserting 300M MYSQL records from 6 Remote Servers on Local using Unique Identifier
I have 6 remote servers that dial phone numbers daily. I have a total record count of over 300 million combined and now I want to procress on them. The table data looks like this using this query
...
- 11
-1
votes
1
answer
355
views
How to create a cronjob backup for mysql slave?
There are few other threads about this question using mysqldump but however i tend to not use mysqldump but instead backup the whole files in /mysql.
I would like to create a cronjob in mysql slave ...
Daniel
0
votes
0
answers
711
views
Schedule Postgres pg_cron jobs to trigger by something other than Cron expression
I have some pg_cron jobs that run at night time. They basically run some plpgsql Procedures and trigger based off CRON expressions.
The problem is that some of my JOBS are dependent on the jobs that ...
- 121
0
votes
1
answer
1k
views
SQL Server create cron job without SQL Server Agent
I'm creating a cron job on SQL Server. As per my knowledge, the only way possible to create a job is through SQL Server Agent. However, the services(listed on services.msc) of VM assigned to me do not ...
- 13
1
vote
2
answers
5k
views
"connection failed" error for pg_cron extension
Installed pg_cron and scheduled job, though there is connection error because job is not done and cron.job_run_details table shows connection failed error message.
As doc says:
Important: Internally, ...
- 495
0
votes
1
answer
832
views
Supabase postgres cron job not working special case
I'm having the problem, while insering a row using rpc through the nodejs library, with user service_role.
i gave permission to all roles. Without exception.
And for service_role I even gave it all ...
- 111
1
vote
1
answer
814
views
Set crontab backup job for Mariadb Databases from 1 remote server to another [closed]
I'm connecting to a Ubuntu Server remotely using SSH, where are x number of MariaDB databases.
Now I want to set a crontab job to automatically create backup for all of them to another server where ...
- 25
0
votes
0
answers
752
views
pg_cron connection refused with postgres login
I am trying to run a function periodically with pg_cron but every time it wants to execute it throws connection refused. the cron job is created using the postgres user.
pg_hba.conf
local all ...
rafaelBackx
1
vote
1
answer
107
views
Programming query execution Postgres
I need to execute update querys routinely over a Postgres table. Is it possible to program an automatic execution of the query, let's say, every day at 15:00 hs? The Postgres version is 9.5, I'm ...
1
vote
4
answers
406
views
Integration: Keep two systems in sync
I have a GIS system with 40 tables, ranging from 1,000 to 60,000 rows per table. The tables are the system of record for assets in a municipality.
The GIS assets in the tables get integrated to a ...
- 1,447
-3
votes
2
answers
3k
views
Need a shell script that can run a oracle query and produce output in .csv format
Can you please help- need a shell script that will have a oracle query inside it and produce a .csv format output in specific location, that script should be a scheduled in a cron job which runs, the ...
0
votes
1
answer
457
views
cron command running postgres at high cpu [closed]
I can see that a cron command is running under a postgres user and killing the CPU but I have no idea how it's being executed or how to stop it !
- 121
0
votes
0
answers
153
views
mysqldump writes dumped data to output
I'm trying to bring incremental backups to one old setup. The script I create worked perfectly when run directly. However when I run it from crontab or when redirecting shell output all data is ...
- 141
0
votes
0
answers
473
views
MySQL pooled connections and crontab jobs (not reusing connections)
I have several cron jobs running and the task that cron has to do is execute a file that in turn checks and compares crawled data with data in the database, if it exists then the script ends and if it ...
- 101
2
votes
1
answer
1k
views
Query to delete all rows which are not referenced in any other tables
Let's say i have a table called images. Images table is referenced in many other tables (movies, books, tv_series) through a foreign key.
My question is if it is possible to write a query which will ...
- 23
0
votes
1
answer
936
views
MongoDB scripts triggered by cron - how to achieve reasonable password security
We would like to do nightly purging of old data out of our mongo cluster. First thought is to write shell script which connects to one of the mongos and issues a remove instruction.
evalString='db.fs....
- 105
5
votes
1
answer
2k
views
Passwordless mysqldump via shell script in /etc/cron.daily
I'm aware that there are dozens of questions similar to this, but it seems none has a definitive answer to my problem, so that's why I'm posting this... I hope in the right place.
The problem:
I ...
- 223
5
votes
1
answer
4k
views
Pg_cron crontab log issue
We're trying to configure periodic jobs in PostgreSQL. To do this, we have installed on Linux machine, with Postgres 9.6 running, the citusdata pg_cron project.
System information:
OS: Linux pg 4.4....
1
vote
0
answers
40
views
What's the best way to programatically have a MySQL DB update another MySQL DB
I am currently working for a service provider that offers Windows software for inventory control. This software connects to a MySQL DB on a dedicated server.
So when this software is updated it ...
- 11
0
votes
3
answers
190
views
How to avoid server crash during backup of dabase using a crontab [closed]
I'm on shared hosting, so I want to avoid using too much system resources.
I have a crontab that schedules a MySQL database backup. The database is about 2gb before compression. When that crontab runs,...
- 1
1
vote
2
answers
4k
views
Routinely deleting aged postgresql rows via cron
I have a Django website with a postgresql 9.3.10 backend. The website contains dynamic user-generated content (think of it as a form of 9gag). There are some tables from which I routinely delete aged ...
- 1,959
2
votes
1
answer
4k
views
CRON and RMAN Backups
We run RMAN backups via CRON jobs, but find the out-of-the-box emails with CRON to almost do what we want. I know we can channel the RMAN output to /dev/null so no email is sent, which for any ...
- 9,342
1
vote
1
answer
3k
views
How does mysqldbcopy function
I have a database called LIVE and I want to create a scenario were I copy the LIVE database every night at 2:30 am. I want the copied database to be called REPORT. So every night I want the REPORT ...
0
votes
1
answer
615
views
MySQL DB Replication
Okay so here's my scenario. I have two applications that share some tables from the same DB. Let's call them App1 and App2. Lets also assume the DB used here is called DB1. App1 and App2.
App1 is on ...
- 101
23
votes
3
answers
147k
views
Date range query for past 24 hour in Mongo shell
I am setting a cron job to collect results from MongoDB database profiler. I'd like to collect results within a 24 hrs period. I plan to run mongo command with javascript.
Question is, in Mongo shell,...
- 1,019
0
votes
0
answers
167
views
Need to Sync Oracle DB table data with mysql [duplicate]
I have a table with some data in oracle which i want to sync with mysql table once in a day, like a cron job.
Is there any tool available which i can use as a cron job in Linux?.
Thanks,
- 111
1
vote
2
answers
1k
views
Are certain environment variables required for mysql login-path?
I created a bash script that backs up my database, db_backup.sh
It basically just runs these commands:
DB=/home/linuxuser/backups/backupfilename.sql.gz
mysqldump --login-path=local db_name | gzip &...
- 1,220
1
vote
2
answers
2k
views
Sync 8 tables of differents databases on same server
I will use eight wordpress websites and i need to sync ther wp-user tables so each single user can connect through all websites.
All of these will be on the same server, using the same MySQL user, but ...
0
votes
0
answers
304
views
What is the best way to execute a MySQL script periodically on Linux
I want to execute some SQL everyday in a Linux server using MySQL to UPDATE some column's values. In order to do that I use the UPDATE ... SET ... WHERE ... statement.
I want to know which is the ...
- 21
2
votes
1
answer
2k
views
Prevent postgres function of running more than 1 instance at the same time
DBMS: Postgres 9.3.4
OS: Debian 7
I have a plpgsql function that will be put in crontab to run every 15 minutes. The function should finish in about 8 minutes, but just in case it takes more than 15 ...
