Questions tagged [jobs]
A scheduled task managed by the database, for example using SQL Server Agent, Oracle dbms_job, or MySQL Event Scheduler.
395
questions
0
votes
0
answers
43
views
What permissions does SQL Server Agent Account needs to run the job?
I am wondering what kind of permissions [NT SERVICE\SQLSERVERAGENT] accounts needs to run the job?
Below are the steps that have been impleemented yet the job doesn't run with correct results expected....
- 577
0
votes
0
answers
34
views
LSRestore job is taking more than 1 hr to complete. Threshold time is 45min
LSCopy and LSRestore job has been scheduled for every 10 mins. I got a trn file on my secondary server after every 6 min from Primary server. LSCopy is synced with LSBackup. The problem is that ...
-1
votes
0
answers
55
views
ORA-27369: job of type EXECUTABLE failed with exit code: 5 Login executable not setuid-root
I try to run executable job in Oracle 19c and the error occurs:
ORA-27369: job of type EXECUTABLE failed with exit code: 5 Login executable not setuid-root
ORA-06512: at "SYS.DBMS_ISCHED", ...
1
vote
0
answers
51
views
Restore Job in MSSQL failing [duplicate]
The backup job of being completed, however, the restoring job is failing.
//EDIT
I am trying to perform logshipping
Getting the following errors:
Date 10/25/2023 4:45:00 PM
Log Job History (...
0
votes
0
answers
38
views
Cannot perform this operation while SqlServerAgent is starting problem
I use SQL Server 2017, this mornnig when i check jobs i got this error;
I searched a lot but couldn't find a solution.
Does anyone know the solution to the problem?
thanks.
- 11
1
vote
1
answer
93
views
SQL Server Jobs - fail on connection timeout
We have a LIVE set of 3 SQL Server instances on one network and a DEV set of 3 SQL Server instances on another. Being on different networks; LIVE cannot talk to DEV however the instances can talk to ...
- 11
0
votes
2
answers
71
views
Report to get difference in SQL Agent jobs across nodes in Availability Group
Is there a script or an article out there to check differences between SQL Agent jobs across nodes in AG and create a report based on the difference? I am not looking for dbatools.io as it syncs the ...
- 5
0
votes
0
answers
19
views
Parameterized Connection Manager in SSISDB Job not using the set ODBC password
Regardless of the solution I find online I have been unable to get my SSMS Scheduled Job to successfully complete my ODBC-connected SSIS ETL Packages.
I have tried deploying the SSIS project/packages ...
0
votes
1
answer
48
views
Schedule a job in SQL Server between two days
How to schedule a job in SQL Server that starts on Wednesday afternoon and it should end on Thursday EOD and between this the SSIS package should execute for every one hour if any error occurs in ...
Charan G
0
votes
0
answers
85
views
Error while using linked server in job. The login is from an untrusted domain and cannot be used with Integrated authentication
In SQL managed instance, I have a job. In job procedure, it is using linked server which is also a SQL managed instance. With test login I can read the data using Linked server. I have created the job ...
- 1
0
votes
1
answer
312
views
SQL Server Job running as different user
A year or so ago I started working on a project to set up a job to run a stored procedure. I've now come back to this to finish it off. When I run the job I get an error that he job is running under ...
- 123
-2
votes
1
answer
132
views
script to place all backup files(Full, diff &log) in same folder for all Databases in the server [closed]
I have downloaded script from here : https://ola.hallengren.com/sql-server-backup.html
Thank you for the SQL Server Backup script, it's creating separate folders & subfolders for each database.
...
0
votes
0
answers
60
views
How to alert when a new SQL Agent Job is created in SQL Server 2019?
How do you alert when a new SQL Agent Job is created in SQL Server 2019? Is there some kind of trigger that would work here?
- 1,087
0
votes
0
answers
260
views
2019 SSIS job step running as a proxy/credential getting "Login failed for user 'domain\user'."
I have a new 2019 SSIS instance with one agent job that runs a package that runs sprocs on another sql instance. The 2019 SSIS sql service and agent service are running under a gmsa. The target ...
- 83
1
vote
0
answers
304
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 ...
0
votes
1
answer
1k
views
Why SQL Server Job fails with "EXECUTE AS LOGIN failed for the requested login"?
I created a SQL Server job, in which:
My user is set as the owner of the job
No user is specified for run as at any step.
The job failed with the error:
'EXECUTE AS LOGIN' failed for the requested ...
- 437
0
votes
1
answer
1k
views
PLS-00306: wrong number or types of arguments in call to 'CREATE_JOB'
we are getting this error when we try to create this scheduler_job but we try to create it give us this error:
BEGIN
DBMS_SCHEDULER.CREATE_JOB
( job_name=>'PROC_TKN_WA_FIX_ARREARS',
job_type=...
2
votes
2
answers
545
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
0
answers
159
views
Big Query Scheduled queries, log of scheduled query changes
We have a Big Query Scheduled queries, an sql developer said the cron of one scheduled query was changed.
I want to find out who changed it.
I think this documentation is the closest I got, but I can'...
- 25
1
vote
1
answer
180
views
pgAgent unwanted delay between jobs start time
I've been trying to make jobs running continuosly, so after previous run is done, the next one starts immediately. I made some initial success with following trigger:
CREATE or replace FUNCTION ...
- 129
0
votes
1
answer
130
views
SQL 2019 multi-step job fails due to output file in use from previous step
We recently upgraded our SQL server from 2012 to 2019. (A long overdue process, I know.)
Prior to the upgrade all of our regular scheduled jobs worked just fine.
After the upgrade, one scheduled job ...
- 356
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
1
answer
1k
views
How can I add time and date to a query output file name in sql server agent job
I have a query set up in SQL Server agent to return an output result file. The problem I have is how to set a date and time stamp so that the file name always includes the date and time.
On the SQL ...
- 13
-1
votes
1
answer
90
views
Any possibility that Ola Hallengren could add a job name prefix option to the script that creates all the maintenance jobs? [closed]
When creating the jobs, they sort together for most of them, but some of the jobs are alphabetically far away from the other Ola jobs on servers with hundreds of jobs.
I would find it easier to see ...
- 99
0
votes
0
answers
292
views
Job getting account disabled Error, but works as normal when executed manually
The account used in a linked external SQL Server was disabled, by the external server, temporaly. After the restoration of access, various job routines that used this account continued working, as ...
- 1
1
vote
3
answers
965
views
How to prevent primary node's SQL jobs from running when the primary node goes into resolving state?
I have 2 nodes in an AG. Non-readable secondary, sync commit mode.
There are sql agent jobs setup on both machines. The schedules are turned off on secondary so those jobs wont run. If there is ...
- 1
1
vote
2
answers
113
views
Problem with Oracle Job Scheduling
I have a job that refreshes a materialised view refresh group on Oracle 19c. I wanted to refresh the group daily at midnight - trunc(sysdate)? The job was made using using the following PL/SQL:
...
- 137
0
votes
1
answer
209
views
On what basis is the sql job's step linked to a database?
I have couple of SQL jobs on source sql server, and on the job step a particular database is selected.
I want to move the databases and jobs on a new sql server, so I have scripted the jobs.
In the ...
- 1
0
votes
1
answer
66
views
What does it mean to reach a stable point during the execution of a job?
Trying to use sp_stop_job to stop a simple job that inserts data on a table when 100 rows were inserted I got confused to see the table end up with more than 100 rows every time.
Under the Remarks ...
- 5,049
1
vote
2
answers
1k
views
SQL Server Backup Jobs Failing. The error seems to be related to MaximumErrorCount, but I am not sure how to fix value or if changing it will resolve?
My backup jobs are failing with following error when check it's history. I have already checked this link regarding maximumerrorcount value: SQL Server 2008 - Change the MaximumErrorCount or fix the ...
4
votes
2
answers
1k
views
Why does this query fail when I run it from a SQL Server job?
I know how to solve the issue, but I don't understand the technicality of why the below query would work when I run it from SSMS, but the same query fails when I add it as a job in the SQL Server ...
- 90
0
votes
0
answers
112
views
Maintenance plan run date wrong
Win server 2019 & SQL Server 2017
On Jan 28th, 2022, I setup 3 maintenance plans to backup 3 databases from 3:00AM – 3:40AM. The last one finishes at 3:45AM. For a few weeks I confirmed that I am ...
- 1
0
votes
1
answer
39
views
Stop Changes to Maintenance Plan from Renaming Linked SQL Agent Job
Is there a way to stop a SQL job (which calls a maintenance plan) from being renamed every time i open and save that maintenance plan?
Each time i do that, a prefix of "_SubPlan" gets added ...
- 11
0
votes
4
answers
1k
views
SQL Agent Job - Change all job steps to go to a specific step when the job fails
I have a SQL Agent Job that I need to change, so that any time any step fails the 'ON FAILURE' action goes to a specific step.
Does anyone have a script or can you show me how to write this so that I ...
0
votes
1
answer
352
views
Scheduling Next Run date for weekly agent jobs
On SQL Server I used maintenance plan wizard to create three jobs:
Job
Schedule
Job 1
Every 3 week on Sunday
Job 2
Every 3 week on Sunday
Job 3
Every 3 week on Sunday
I want the three jobs to run ...
- 441
0
votes
1
answer
624
views
DBCC CHECKDB job failed on SQL Server 2014
We have a DBCC CHECKDB job that runs weekly on Saturdays. This job was created thorugh Maintenance Plan wizard. Typical duration for this job is 1.5 hours. This past weekend the job failed with the ...
- 83
1
vote
0
answers
539
views
Sql Server Agent Job - Unable to start execution of step 1 (reason: Error authenticating proxy "user", system error: The user's account has expired.)
My predecessor created several "Intergration Services Catalogs" dtsx packages which are scheduled / run via SQL Server Agent -> Jobs using an SSISFileProxy which is using ...
- 11
2
votes
1
answer
1k
views
Job to stop other job at specific time
We have a job which imports data daily from a remote SQL Server every night, I'll call it Import-Job. Most of the time this job runs through in about 15 minutes and everything is fine but due to a ...
- 131
0
votes
1
answer
830
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
467
views
Need help in getting mysql event scheduled every monday and wednesday
I have coded an event as below to run every Monday and Wednesday, but it runs only on Monday and doesn't on Wednesday.
delimiter |
CREATE EVENT IF NOT EXISTS evnt_demo_ref_fs_test
ON SCHEDULE EVERY 1 ...
- 1
0
votes
1
answer
109
views
Would re-seeding the InstanceID column of sys.jobhistory table create issues?
I have two Production servers, one active, one passive. On the active server, application specific jobs are enabled and run all the time. Jobs on the passive server do not run.
On a regular schedule, ...
- 1
0
votes
0
answers
579
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
-1
votes
2
answers
385
views
SQL Server Agent Jobs and Availability group
I have two servers (Primary and Secondary), as well as an AG that keeps them in sync.
As we all know, System databases are not covered by the AG definition.
1.I require that all jobs on the primary ...
- 1
0
votes
0
answers
60
views
Cannot modify a job in SQL 2008 R2. The Modify window simply doesn't come up
I created a maintenance plan to perform daily backups with transaction log backups to be scheduled on four hour increments, however, I did not enable the job immediately, nor did I enter add the ...
- 21
0
votes
2
answers
130
views
Job to remove logins on secondary replica that don't exist in primary replica
How to remove logins on a secondary replica that don't exist in primary replica?
I want to create automated jobs that should check if the login still exists on a secondary after the login on the ...
- 1
2
votes
1
answer
170
views
How to trim the log file that stores information about job history execution?
I was having a look at my sql server jobs and proxies on an specific server in the production environment.
I pretty much have an script to check the status of the jobs but in case I have to ...
- 15.8k
0
votes
1
answer
358
views
Archive logs Pg_archive cleaner
I have Postgres installed on windows 10. I have master-slave replication ( 1 pc is master and 2 other pc are slaves). I have archive logs saved on a file on master pc and slaves are connected to that ...
- 21
2
votes
1
answer
159
views
Jobs on the Mirror are running against the Primary
I have a mirrored set of jobs between the my current primary and mirrored failover SQL Server setup. In the past, the jobs on the mirrored server, when they are enabled, fail as they are not able to ...
- 1,771
1
vote
1
answer
420
views
*.bak file on another server file share
On a physical Dell server, I am trying to setup a backup job to *.bak file on to failover server.
In the video, DBA Fundamentals - backup 3 - setting up maintenance plans @6:24 backing up to a local ...
- 21
3
votes
2
answers
8k
views
Cannot give NT SERVICE\MSSQLSERVER permissions on network drive
I have an SSIS package that I would like to run as a job. The flat file source sits on Server A while the package and job sit on Server B.
When I run the job that executes the SSIS package I get an ...
- 33