Questions tagged [jobs]

A scheduled task managed by the database, for example using SQL Server Agent, Oracle dbms_job, or MySQL Event Scheduler.

Filter by
Sorted by
Tagged with
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....
xorpower's user avatar
  • 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 ...
Ajit23jss9's user avatar
-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", ...
kalisto-87's user avatar
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 (...
datascinalyst's user avatar
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.
shnsrl's user avatar
  • 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 ...
Drees's user avatar
  • 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 ...
mk SQL's user avatar
  • 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 ...
funkyman50's user avatar
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 ...
user avatar
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 ...
Narendra's user avatar
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 ...
Keith Miller's user avatar
-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. ...
CHAITANYA REDDY's user avatar
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?
user2368632's user avatar
  • 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 ...
Bobogator's user avatar
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 ...
Abhinav Shenoy's user avatar
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 ...
HeyJude's user avatar
  • 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=...
Daniel Soto's user avatar
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 ...
HookSQLDBA7's user avatar
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'...
AJ AJ's user avatar
  • 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 ...
sh4rkyy's user avatar
  • 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 ...
Hellion's user avatar
  • 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 ...
Stavros Koureas's user avatar
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 ...
Debby's user avatar
  • 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 ...
EricI's user avatar
  • 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 ...
gabril's user avatar
  • 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 ...
variable's user avatar
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: ...
Huskie69's user avatar
  • 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 ...
variable's user avatar
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 ...
Ronaldo's user avatar
  • 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 ...
Syed sabeeh Ahmed Fatmi's user avatar
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 ...
SAKA UK's user avatar
  • 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 ...
Lansend's user avatar
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 ...
SQLNewbie's user avatar
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 ...
Asha Richardson's user avatar
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 ...
Salman A's user avatar
  • 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 ...
sqllover2020's user avatar
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 ...
Wyvernstail's user avatar
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 ...
Manu's user avatar
  • 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 ...
Mohamed Allal's user avatar
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 ...
Mushtaq's user avatar
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, ...
RickS's user avatar
  • 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 ...
Ohmi i's user avatar
  • 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 ...
Vamsi's user avatar
  • 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 ...
Tom's user avatar
  • 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 ...
Ella's user avatar
  • 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 ...
Marcello Miorelli's user avatar
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 ...
Anisa Ibro's user avatar
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 ...
Aaron's user avatar
  • 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 ...
ricknut's user avatar
  • 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 ...
Cody Francis's user avatar

1
2 3 4 5
8