Questions tagged [scheduled-tasks]

The tag has no usage guidance.

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

Scheduled task in windows server does not appear in PostgreSQL log file

PostgreSQL 14 - Windows Server 2012 I have a scheduled task every day at 5 AM. It executes an sql file with an update query and some refresh materialized views. According to Windows Server, the task ...
Leehan's user avatar
  • 207
0 votes
1 answer
22 views

Does the BigQuery API offer a way to retrieve info on scheduled queries?

Using the BigQuery C# API, I can retrieve a list of job IDs: BigQueryClient _client = BigQueryClient.Create(...); ... foreach (var page in _client.ListJobs(projectId).AsRawResponses()) if (page....
Jon of All Trades's user avatar
0 votes
0 answers
465 views

pg_cron jobs are not being executed

We have installed pg_cron extension on PostgreSQL 13 database. postgresql.conf file: shared_preload_libraries = 'pg_cron' cron.database_name = 'pg_cron_db_name' Also we enabled trust authentication ...
Lesya Klachko's user avatar
0 votes
0 answers
70 views

Oracle database connection performance dropped to bottom, causing severe performance issues in web application and scheduler job failures

We have some batch scripts as task scheduler jobs, which are running good from few years. These jobs connects to DB and will do multiple inserts and update operations using sqlplus, sqlldr and java ...
user avatar
1 vote
0 answers
355 views

Unable to create and install pgAgent service

I'm trying to install pgAgent on my device. During the installation using the stackbuilder, the last step requires me to add the operating system username and password as below: However, after ...
Abhinav Shenoy's user avatar
2 votes
2 answers
714 views

Create a Job Schedule that runs on the 1st of month only if it falls on a Sunday

This job already has one schedule that runs on the first of the month. However, we need to run the job on a different schedule if the first of the month falls on a Sunday. It appears to me that the ...
HookSQLDBA7's user avatar
0 votes
1 answer
192 views

Can we do incremental sync of MongoDB based on a schedule?

Can we sync a mongodb database to another incrementally based on a schedule? Say, once every night at 12 am? Background: We have a MongoDB replica cluster consisting of 3 instances, all located within ...
esafwan's user avatar
  • 133
0 votes
1 answer
297 views

SQL Agent Job fails after upgrade to SQL 2017

I have upgraded a database to SQL 2017. A SQL Agent Job that previously ran now fails with this error: Unable to start execution of step 1 (reason: JobOwner DOMAIN\USERNAME doesn't have permissions ...
JosephStyons's user avatar
7 votes
2 answers
2k views

When did this SQL request yield results?

I'm working on an SQL server database, containing orders and machines, executing those orders. Not more than one active order can be assigned to a machine at the same time. In other words: this SQL ...
Dominique's user avatar
  • 523
0 votes
1 answer
926 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 ...
Mohamed Allal's user avatar
0 votes
1 answer
967 views

How to send alert on SQL Shutdown due to Audit Failure

Looking for a way to implement this STIG. What method should I use to monitor SQL Server, when it is shutdown due to "Shutdown on Audit Failure"? SQL Server must provide an immediate real-...
Keybonesabi's user avatar
0 votes
0 answers
612 views

How to schedule a job using windows task scheduler to export data from potgresql eriodically into CSV file.?

I am facing an issue even after following all the steps as suggested in the answer provided by Neil Mcguigan for the question asked In the above link I was getting an error - "psql: f_sendauth no ...
Ohmi i's user avatar
  • 1
0 votes
0 answers
58 views

MySQL scheduled events not working on newly-added data

I can get a scheduled event to perform calculations on a current table. But it won't perform calculations on any new rows that are added to the table. How can I get the event to use the current ...
Normajean's user avatar
  • 101
0 votes
2 answers
4k views

Run query every 5 minutes

Please find the below query: select count(*) from v$session; This has to be run on the database every 5 minutes. What is the right way to achieve this? The query has to be run every 5 minutes on the ...
Abstract Circle's user avatar
0 votes
0 answers
199 views

Automate Microsoft SQL Script and send the Result to email

My organization asked me to setup monitoring for below query and the query needs to run every hour(Automated) , if the below query status results other than STARTED or COMPLETED send them as failure ...
phani's user avatar
  • 9
-1 votes
2 answers
935 views

Why would a scheduled job fail in SQL Developer?

I am trying to create a scheduled job in Oracle SQL Developer that would run once a month and I am testing the Scheduler/Jobs feature where I have created a simple SQL query to test the ability to do ...
Andrew Hicks's user avatar
0 votes
1 answer
117 views

Oracle 11g - Database Job About User Lock

I have an Oracle database (Oracle 11gR2) and I want to create a job. The job will trigger my procedure. The procedure must comply with the rules I have specified below: If a user's expiry_date value ...
jrdba's user avatar
  • 55
0 votes
0 answers
27 views

Error when creating scheduled event?

I creating scheduled events in MySQL 5.5 (yes, I know, and we do have plans for upgrading, but we're kind of trapped here atm). I have done this before, like: create event upd_ga_sum_1 on schedule ...
j4nd3r53n's user avatar
  • 221
0 votes
3 answers
3k views

Oracle 12c and Jobs running one hour apart after changing time for hourly use

I have an Oracle 12c database in which I have detected that the scheduled jobs are running one hour apart after the change of time on the server, checking in the database I see that the SYSTIMESTAMP ...
miguel ramires's user avatar
4 votes
1 answer
2k views

Why the job's next_run_time is wrong?

I got an issue regarding job stats. So I have a job with the following schedule: Occurs every day every 5 minute(s) between 12:00:00 AM and 11:59:59 PM. Schedule will be used starting on 12/13/2017. ...
Rauf Asadov's user avatar
  • 1,253
0 votes
1 answer
2k views

How can I run a pgAgent job every 10 second?

I have a PostgreSQL 11.3 Database. I installed pgAgent for creating jobs. Now I want to run my job every 10 second, but in GUI there is possibility to write with precision of minutes, not with ...
JiboOne's user avatar
  • 103
0 votes
1 answer
3k views

Run a stored procedure only the last 3 days in a month

How can I run a stored procedure only the last 3 days of a month using a T-SQL script?
Phanindra Pothuri's user avatar
1 vote
2 answers
273 views

SSIS connection used based on passed value

I have an SSIS package that populates a reporting warehouse from a live and test environment. Currently the package has each step duplicated as the source connection changes between live and test. ...
Round's user avatar
  • 123
1 vote
1 answer
763 views

executing a stored procedure on a monthly schedule

I'm looking to create an invoicing procedure that executes automatically once a month. The procedure name is INVOICE_PROC. I have tried to use a trigger to execute it but I can't get it to work. ...
MitchallC's user avatar
0 votes
1 answer
3k 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 ...
F T's user avatar
  • 11
1 vote
2 answers
2k views

Run shell script on Oracle 11g

I have an oracle database: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production "CORE 11.2.0.1.0 Production" TNS for Linux: Version 11.2.0.1.0 - ...
Wolfy's user avatar
  • 113
1 vote
2 answers
3k views

Stop long running scheduled job

I need to launch a scheduled job at 12 o'clock at night and keep this job running for a period of 8 hours. What happens now is that the job is running for more than 12 hours and I really need to avoid ...
Arnaldo Raxach's user avatar
2 votes
1 answer
41 views

Schedule database backup question

Good day. This may be a stupid question and you can give me a stupid answer if you need to. I know you can schedule a task to backup a sql database at logon, shutdown, specific time, etc. But What I ...
Christopher Hart's user avatar
1 vote
2 answers
8k views

How to stop the SQL Server Agent Job Scheduler with T-SQL?

I have a job that I manually start in coordinated time periods that does a bunch of heavy lifting (mostly restoring backups and configuring for a different server) There are several jobs scheduled to ...
James Jenkins's user avatar
2 votes
2 answers
547 views

How to find a SQL Job details in Production environment?

There is a stored procedure being executed daily which inserts a record in a specific table. Our Production database servers has lot of SQL jobs scheduled to run daily at different intervals. How to ...
Sri's user avatar
  • 393
0 votes
1 answer
48 views

Regularly clone/backup 2 MySQL databases unidirectionally from PC to Laptop both running Windows

I have a PC running Windows XP with a custom ERP system and MySQL Server 4.x (A) and a Laptop running Windows 10, same MySQL 4.x and same custom ERP (B). I'm afraid I can't upgrade PC nor MySQL, etc. ...
Enrique's user avatar
  • 123
1 vote
1 answer
298 views

Create a job from dbms_scheduler with stream redirection?

I want to create a simple job who have to execute this shell command: echo some_text > some_file The attributes some_text and some_file can change between two calls to run_job so I need to use ...
Pierre's user avatar
  • 177
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....
Martina Muscariello's user avatar
13 votes
3 answers
29k views

Automatically execute query in MS SQL Studio every hour

I support an application in a big enterprise, one of my roles is to clean-up data. There is a query I need to execute every hour, and I would like to automate it. Due to organization policies, I can't ...
Ivan Koshelev's user avatar
1 vote
1 answer
57 views

Serializability schedules: can someone help me understand it?

I am struggling with the Databases courses I have, so I am trying to find answer to my question. This has been asked: Add the appropriate locks to enforce serializability on the following schedule: ...
Siyah's user avatar
  • 113
3 votes
3 answers
6k views

Ways to Schedule Rman backups

I am using oracle 11g database in windows platform. Also, my db is in archivelog mode and I am taking daily RMAN backups. Now, I need to schedule my Rman backups on daily and weekly basis. I read ...
SHS's user avatar
  • 152
3 votes
2 answers
696 views

Scheduling queries to run when sql server is not busy

Is it possible to schedule some queries not for specific times but to run when sql server is not busy? Is there any way to calculate the business of the sql server?
Ashkan Mobayen Khiabani's user avatar
0 votes
1 answer
42 views

How to create a CSV file which imports data from an Access Database on a Weekly Schedule?

I have very little experience in database management but have come across a problem I am unable to find a solution to online. I currently have access to a database which is updated in real time with ...
George's user avatar
  • 103
2 votes
2 answers
65 views

Generating Backups of Databases

I would like to create a backup of four databases on one SQL Server 2000 instance at the exact same moment in time. How can I achieve it? Creating different jobs with the same schedule date and ...
Jennifer Fuss's user avatar
2 votes
1 answer
2k views

what does that mean? COMMAND [PeriodicTaskRunner] task: UnusedLockCleaner took: 273ms

With mloginfo I found a strange log entry. Didn't find anything about it in MongoDB docs and other related sites. $ mloginfo mongodb.log --distinct source: mongodb.log host: example ...
Sybil's user avatar
  • 2,488
1 vote
2 answers
2k views

Is there any way to Rebuild (and Reorganize) the indexes automatically?

I have created some non-clustered index on my tables in SQL Server 2014. Is there any way to Rebuild (and Reorganize) the indexes automatically? I mean is it possible to schedule them to be built ...
Nasseh's user avatar
  • 111
0 votes
1 answer
665 views

Always On: SQL Agent can still run stored proc on inactive server

We have the AO Clustering - HA&DR Hybrid configuration. Out of a dozen databases only this one database/application is encountering this. The problem is that we have a SQL Agent Job scheduled to ...
George's user avatar
  • 1
1 vote
1 answer
1k views

how to find out the next time a job is scheduled to run in sql - in real time and even if the job has never been run before

I have a very similar question here but the problem with that question/ answer is that it does not work for all situations. for example, for the jobs that I have just created and have not been run as ...
Marcello Miorelli's user avatar
0 votes
0 answers
24 views

SQL Server Job does not execute when scheduled, but does execute manually, how do I get it to run as scheduled? [duplicate]

I am running SQL Server 2014 SP 1 CU 5. The job did work in the past. The schedule is enabled. The account it is running under is an ADS account which has sysadmin rights and has delete rights to the ...
Michael's user avatar
  • 31
1 vote
1 answer
1k views

pg_dump fails to create a backup when running from System User in Windows Task Scheduler

I am trying to run a pg_dump through a scheduled task in windows. I have two batch files. One creates the task. The other one runs the pg_dump. Even though the pg_dump works with the current user with ...
wondim's user avatar
  • 111
1 vote
1 answer
4k views

Automate backup using Windows Task Scheduler

I want to run an automatic backup of SQL Server 2012 Express using Windows Task Scheduler. I have 3 user databases. I want to backup all 3 user databases through a single stored procedure and a ...
Md Haidar Ali Khan's user avatar
7 votes
2 answers
43k views

Insufficient disk space in Filegroup

One of my jobs is failing and it shows below message. Error: Could not allocate a new page for database 'Reporting' because of insufficient disk space in Filegroup ‘PRIMARY’. Create the necessary ...
Aruna Raghunam's user avatar
1 vote
0 answers
186 views

Bypass stored procedure execution CPU consumption

We are using Microsoft SQL Server Agent Jobs to execute stored procedures on the other database systems (like MySQL or Oracle). Usually we run procedures via linked servers (over OLEDB and ODBC ...
Dmitry Logvinenko's user avatar
1 vote
1 answer
674 views

Most efficient table storage for determining recurrence

What is the most optimal table structure to store schedules / recurrence definitions so that we can efficiently query it for all events that will occur within a date range (min:1 max:32 days)? My ...
孔夫子's user avatar
  • 4,330
1 vote
1 answer
77 views

Backup a MySQL database -options

I'm relatively new to database driven sites. In order to backup a database I use phpMyAdmin's Export function from the server and download the output to my computer. That works, but it requires me to ...
user avatar