Questions tagged [cron]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
3answers
95 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 ...
-3
votes
2answers
60 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
1answer
83 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 !
0
votes
0answers
29 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 ...
0
votes
0answers
40 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 ...
1
vote
1answer
91 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 ...
0
votes
1answer
399 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....
2
votes
1answer
761 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 ...
5
votes
1answer
1k 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
0answers
29 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 ...
0
votes
3answers
110 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
vote
2answers
944 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 ...
2
votes
1answer
2k 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 ...
1
vote
1answer
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
1answer
576 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 ...
13
votes
3answers
91k 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,...
0
votes
0answers
25 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,
1
vote
1answer
756 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
vote
2answers
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
0answers
228 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 ...
2
votes
1answer
1k 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 ...