Questions tagged [scheduled-tasks]
The scheduled-tasks tag has no usage guidance.
57
questions
0
votes
0
answers
6
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 ...
Shadowtest
1
vote
0
answers
194
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 ...
2
votes
2
answers
249
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 ...
- 41
0
votes
1
answer
126
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 ...
- 133
0
votes
1
answer
200
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 ...
- 111
0
votes
0
answers
53
views
Can I run scheduled job as sysdba?
I have user c##admin in my core DB (Oracle 19c), with "sysdba" privileges.
I want it to select from a pdb using a database link without giving a password.
assuming the following:
PDB Name: ...
- 862
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 ...
- 513
0
votes
1
answer
659
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
0
votes
1
answer
657
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-...
- 21
0
votes
0
answers
470
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 ...
- 1
0
votes
0
answers
42
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 ...
- 101
0
votes
2
answers
3k
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 ...
0
votes
0
answers
154
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 ...
- 9
-1
votes
2
answers
728
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 ...
- 111
0
votes
1
answer
80
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 ...
- 55
0
votes
0
answers
25
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 ...
- 231
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 ...
- 137
4
votes
1
answer
1k
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.
...
- 1,233
0
votes
1
answer
1k
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 ...
- 103
0
votes
1
answer
2k
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?
1
vote
2
answers
149
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. ...
- 123
1
vote
1
answer
632
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. ...
- 11
0
votes
1
answer
2k
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 ...
- 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 - ...
- 113
0
votes
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 ...
- 125
2
votes
1
answer
39
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 ...
1
vote
2
answers
7k
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 ...
- 6,158
2
votes
2
answers
239
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 ...
- 393
0
votes
1
answer
36
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. ...
- 123
1
vote
1
answer
262
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 ...
- 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....
13
votes
3
answers
26k
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 ...
- 245
1
vote
1
answer
56
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:
...
- 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 ...
- 152
3
votes
2
answers
653
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?
0
votes
1
answer
40
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 ...
- 103
2
votes
2
answers
59
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 ...
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
...
- 2,338
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 ...
- 111
0
votes
1
answer
621
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 ...
- 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 ...
- 15.5k
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 ...
- 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 ...
- 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 ...
- 6,301
5
votes
2
answers
40k
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 ...
- 163
1
vote
0
answers
170
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 ...
1
vote
1
answer
617
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 ...
- 4,320
1
vote
1
answer
74
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 ...
parboy
2
votes
1
answer
8k
views
SSIS Package Validation Error when Executed From Windows Task Scheduler
I have deployed my SSIS package using the project deployment model to the SSIS catalog and experience a strange validation error when I try to execute the package. I believe this is due to a ...
- 81
2
votes
0
answers
172
views
Scheduling a task to run after a SQL SERVER 2012 executes a different set of scripts?
Im working on a project for a job I am interning for. I've had a few months of database design. I am still learning all the techniques.
I am currently trying to schedule a console app to run every ...
- 21