Questions tagged [scheduled-tasks]
The scheduled-tasks tag has no summary.
63 questions
1
vote
2
answers
70
views
Dynamically Adjusting max server memory Between Two Instances
I’ve got one server with two SQL instances. The server has 128 GB RAM.
Instance 1 has peak load from 08:00–10:00
Instance 2 has peak load from 14:00–17:00
Currently:
Instance 1 has max server ...
- 21
0
votes
0
answers
56
views
How to Calculate the Next Interval of a Every X Months Schedule Given the Current Date and a Start Date
This may be a daft question as it is coming from a foggy mind. I am trying to determine when the next interval will be of a job that is scheduled to fire on the last day of every x month. In a query, ...
- 683
2
votes
1
answer
246
views
Disabled SQL Server job still being run
SQL Server 15.0.4395.2
We have a SSIS package that we run to interface with another system. It is (or was) run from a SQL Server Agent job, and scheduled to run every hour.
For reasons outside the ...
- 121
-1
votes
1
answer
292
views
Can AWS services replace SQL Server Agent Jobs?
I've decided that I no longer want to use SQL Server Agent Jobs. They're tightly coupled to SQL Server, cause interesting security/permissions problems, and can be complicated to sequence. I instead ...
- 1,248
0
votes
0
answers
71
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 ...
- 205
0
votes
1
answer
80
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....
- 5,985
0
votes
0
answers
2k
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 ...
0
votes
0
answers
102
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
610
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
1k
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 ...
- 71
0
votes
1
answer
218
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
381
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
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 ...
- 609
0
votes
1
answer
1k
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
2
answers
1k
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