Skip to main content

Questions tagged [jobs]

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

68 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5 votes
2 answers
5k views

Issues running SSIS package as SQL Server Agent job

I've got some ridiculously stubborn difficulties when trying to run SSIS packages SQL Server Agent jobs on two SQL Servers, one in a domain and one without. I've read hundreds of posts on dozens of ...
gemisigo's user avatar
  • 343
4 votes
1 answer
2k views

How do I identify the remote db agent name to use in create_database_destination on Oracle 11gR2?

I am trying to setup DBMS_SCHEDULER in Oracle 11g to run a remote database job. I have a remote Oracle 11g R2 database on unix and a local one on Windows. I read that you can install the oracle ...
Trevor North's user avatar
3 votes
0 answers
2k views

Getting email notification when jobs are created under user_schema rather than sys?

I log in as sys and set the smtp for scheduler: BEGIN DBMS_SCHEDULER.set_scheduler_attribute('email_server', '10.1.1.15'); DBMS_SCHEDULER.set_scheduler_attribute('email_sender', '[email protected]')...
daksh's user avatar
  • 31
2 votes
1 answer
729 views

Installing SSIS package outside of SSIDB catalog

I'm trying to simplify deployment of a SSIS package to a remote server. At the moment, I have Local Visual Studio SSDT and SSIS package that has 4 connection managers - DEV environment Remote server ...
Anonymous's user avatar
  • 143
2 votes
0 answers
1k views

PowerShell Script Not Working on SQL Server Job Step

I've some .CSV files generated in a shared folder \\SERVER01\DIR\Current and would like to copy to another folder in same server \\SERVER01\DIR\Archive. The script needs to copy, rename files adding ...
AdemirP's user avatar
  • 21
2 votes
1 answer
43 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 ...
Christopher Hart's user avatar
2 votes
0 answers
146 views

Is it possible for a user that is not the job owner to edit the job or add new steps?

My development lead is ok to revoke the sysadmin privileges he currently has, if there is a way he can still edit/execute/enable-disable/execute application jobs. So far, I see that with the ...
Debbie's user avatar
  • 303
2 votes
0 answers
326 views

Configuring SQL Server Job agent

I am trying to configure the SQL Server Job Agent using the following scripts USE [msdb] GO CREATE USER [mydbuser] FOR LOGIN [mydbuser] GO EXEC sp_addrolemember N'db_datareader', N'mydbuser' GO EXEC ...
user824910's user avatar
1 vote
0 answers
67 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
1 vote
0 answers
64 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
1 vote
1 answer
143 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
1 vote
0 answers
401 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
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
1 vote
0 answers
664 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
1 vote
1 answer
452 views

Schedule suggestion and index rebuild / database integrity progress for Ola Hallengren’s Maintenance Script

I have to configure Ola Hallengren's Maintenance Scripts for my SQL Server 2017. SQL Database size about total 400GB.Total 10 Dbs. But I have some questions. 1- I will use these schedules like below. ...
Cell-o's user avatar
  • 1,088
1 vote
0 answers
260 views

Oracle Scheduler Job - Exporting of CSV File every 16:01

I have already executed the code for scheduler. However, I have a problem whenever I execute my scheduler. Can someone help me with this? I'll appreciate all your response. My procedure code: create ...
stummyhurts's user avatar
1 vote
1 answer
494 views

Target server is not communicating(polling) with master SQL Server

We set up multi-server administration to create a job on the master which are executed on target servers, and we had this issue because the target server was shut down after a virus attack and we set ...
Liza's user avatar
  • 11
1 vote
2 answers
154 views

SQL SERVER Detailed Backup Report

I need to create a script that gives the report for the following information: Backup Job Name Databases that have been backed up in the last 24 hours Size of each DB backup Start time of backup End ...
sqllover2020's user avatar
1 vote
0 answers
453 views

Why is failed job not logged in SQL Server Agent Error Log?

I have a failed job which is logged in SQL Server Logs but not logged in SQL Server Agent Error Logs. The job is executed as user: NT SERVICE\SQLSERVERAGENT. Limit size of job history and Remove agent ...
Rauf Asadov's user avatar
  • 1,273
1 vote
1 answer
1k views

Mysql 8 event scheduler timezone

I'm a bit confused about the event scheduler. First off, it is running and working, but the timezone handling confuses me a bit, as it seems it's not what is documented on events metadata It says ...
Sebastian Witt's user avatar
1 vote
0 answers
478 views

OLA Output File Cleanup - Better Options

Does anyone have a way to change the Ola Hallengren "Output File Cleanup" job that doesn't require CmdExec? My company is trying to eliminate CmdExec where ever possible. I was thinking a PowerShell ...
JonDBA5420's user avatar
1 vote
0 answers
423 views

SSIS FTP Package job fails when scheduling through SQL Server Agent job

I am using WinSCP inside SSIS Execute task for downloading and moving the file in FTP location. It works great through visual studio. I am passing parameters inside the SQL Server Agent job and the ...
hadrian blackwater's user avatar
1 vote
0 answers
190 views

How to verify DBCC CHECKDB

I am logging the DBCC CHECKDB job output to a table. When I look at the job log using the below command, I want to verify that all is well. use msdb EXEC dbo.sp_help_jobsteplog @job_name = N'...
cspell's user avatar
  • 501
1 vote
0 answers
884 views

Time-out tempdb

When the job is running, it takes a time-out error. Usually it works, sometimes get any errors. Job schedule : Occurs every day 3 minute Time-out occurred while waiting for buffer latch type 3 for ...
Yunus UYANIK's user avatar
  • 1,099
1 vote
0 answers
1k views

Maintenance Plan job failing with access denied for NT SERVICE\SQLSERVERAGENT

I used the Maintenance Plan Wizard under SQL Server 2014 to create a simple maintenance plan that once a week: Check Database Integrity including indexes Rebuild Indexes Clean Up History When the ...
David Henderson's user avatar
1 vote
0 answers
152 views

Getting non owner to execute a job

I've attempted to implement solution three from the following Q & A: Allow non-sysadmin, non-owner of a SQL Server Agent job to execute it Table created and stored procedure created in msdb, ...
Lisa M's user avatar
  • 11
1 vote
0 answers
6k views

Failed to execute IS server package because of error 0x80131904 ... System.ComponentModel.Win32Exception: The handle is invalid

I have an SSIS package that is executed every 30 seconds by a SQL Agent Job. Every few days, an execution will fail with this message in the Job History: Failed to execute IS server package because ...
Mark Freeman's user avatar
  • 2,181
1 vote
0 answers
273 views

MySQL Event scheduler not generating CSV

The scheduler seems to be running from INFORMATION_SCHEMA.EVENTS but there is no CSV output. The event scheduler has to automatically produce a csv to pass on the data to another system. It's like ...
mish's user avatar
  • 11
1 vote
0 answers
367 views

SQL Server 2014 proxy error

I'm rather confused by this one and can't see any options in previous posts about similar things. I've created a credential -> proxy account, that will run a PowerShell script. When I run the ...
Staggerlee011's user avatar
1 vote
0 answers
735 views

oracle AQ for scheduled jobs

We have a process that currently uses the Oracle DBMS_SCHEDULER to execute. The process runs every time the backend receives data from an external device. The Oracle scheduler is set up such that a ...
mlehmeher's user avatar
1 vote
0 answers
826 views

MySQL event scheduler doesn't work

I have the following MySQL event sheduler to udpate some values in RECETAS table's ESTADO column. I want to run it everyday at 10:05:00. CREATE EVENT IF NOT EXISTS actualizar_prueba ON SCHEDULE ...
william's user avatar
  • 21
1 vote
1 answer
1k views

SQL Server allow viewing of jobs by job category

I know how to assign or create "categories" for jobs. But is there a way to actually view jobs by category by default. I do not want to see all the jobs just listed within SQL Server Agent. I'd ...
JonH's user avatar
  • 289
1 vote
2 answers
2k views

Cannot run a job to update table on a linked server

I am running SQL Server 2012 on a server (server 1) and have set up a job to run a stored procedure which will summarize data from a series of tables and update a table on a linked server (server 2) ...
Tim's user avatar
  • 11
0 votes
1 answer
25 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
0 votes
0 answers
21 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
114 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
0 votes
0 answers
59 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
0 votes
0 answers
69 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
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
0 votes
0 answers
35 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
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
0 answers
351 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
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
2 answers
556 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
150 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
632 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
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