Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
1 answer
21 views

SQL Server Replication - only ran once. How to configure scheduler from beginning

I have configured a transactional replication from server A to Server B some 2 month ago. The source database is a new production server, and the data is being updated there constantly. I have some ...
Dmitriy Ryabin's user avatar
0 votes
0 answers
6 views

Serialisable Schedule but not View Serialisable

These are the definitions I have for Serialisable and View Serialisable. I know that View Serialisability => Serialisability and I want to find an example of a schedule that is Serialisable but ...
revision's user avatar
-1 votes
1 answer
110 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 ...
J. Mini's user avatar
  • 433
0 votes
0 answers
19 views

Run SQL Server Agent T-SQL Job step under another Windows Account

This may look like a duplicate of this post, but the case differs. Here is the complete situation: I have access to 172.31.50.98 using my Windows Domain Account I have added 172.31.50.98 to my ...
Mohammad's user avatar
0 votes
1 answer
93 views

How automate backup and restore in Azure SQL Managed Instance?

I'm the DBA of one Azure SQL Managed Instance and one of our clients asked us if is possible automate a backup and restore in order to have a copy of one of the database before one of our ETL procces ...
SakZepelin's user avatar
1 vote
0 answers
61 views

SQL script to run from batch jobs

I have a sql script that truncates the table and insert into database from a linked server.Since the server is SQL express I will need to use batch jobs to schedule the jobs. Below is a snippet of the ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
1 answer
99 views

Oracle: How can a job exist and not exist at the same time?

I am trying to fix a job by deleting it and then recreating it. But I can't because it seems to not exist when I try to drop, and then exist already when I try to create Begin dbms_scheduler....
Christian Bongiorno's user avatar
0 votes
0 answers
56 views

Autogrow Alert/Job not working, WMI(FileName) not found

im trying to set up an alarm that notifies me when an auto grow is happening,im using this link material to create everything https://www.mssqltips.com/sqlservertip/3128/monitor-sql-server-database-...
Golosie Emanuel's user avatar
1 vote
0 answers
60 views

How to send job notifications with dbms_scheduler via ssl encrypted smtp

We have Oracle Enterprise 19 Databases installed on Linux and using job notification via smtp with Oracle dbms_scheduler for quite a long time. Defining jobs like this and having all the needed ...
nightbird1972's user avatar
0 votes
0 answers
66 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
43 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 vote
0 answers
52 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
52 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
138 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
169 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
32 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
72 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
106 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
740 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
175 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
1 vote
0 answers
387 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
2k 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
  • 447
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
770 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
1 vote
1 answer
211 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
  • 139
0 votes
1 answer
191 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
  • 381
0 votes
2 answers
2k 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
2k 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
112 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
348 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
1k 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
  • 3,636
1 vote
2 answers
131 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
259 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
  • 3,636
0 votes
1 answer
67 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,091
1 vote
2 answers
2k 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
  • 100
0 votes
0 answers
132 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
42 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
2k 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
390 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
  • 461
0 votes
1 answer
715 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
661 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
972 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
550 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
146 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
626 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
472 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
64 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
146 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

1
2 3 4 5
8