Questions tagged [jobs]
A scheduled task managed by the database, for example using SQL Server Agent, Oracle dbms_job, or MySQL Event Scheduler.
369
questions
0
votes
1answer
35 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 ...
-2
votes
0answers
13 views
'DerivedBackGroundPrinted.ExecuteAsync(CancellationToken)': no suitable method found to override [closed]
Writing the BackGround Service in DotNet core, I got the error:
ERROR:'DerivedBackGroundPrinted.ExecuteAsync(CancellationToken)': no suitable method found to override BackGroundTask.Demo
Here is ...
0
votes
0answers
20 views
Scheduled job not present on database, but visible from dba_scheduler_job_log
I'm seeing this error in the alert log (sorry, it's in italian!):
*** 2021-09-14 23:50:17.891
*** SESSION ID:(249.6897) 2021-09-14 23:50:17.891
*** CLIENT ID:() 2021-09-14 23:50:17.891
*** SERVICE ...
1
vote
0answers
33 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 ...
2
votes
1answer
93 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 ...
0
votes
1answer
18 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 ...
0
votes
2answers
31 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 ...
0
votes
1answer
40 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, ...
0
votes
0answers
58 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
votes
1answer
40 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 ...
0
votes
0answers
37 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 ...
0
votes
2answers
44 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 ...
2
votes
1answer
53 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 ...
0
votes
1answer
34 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 ...
2
votes
1answer
47 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
vote
1answer
71 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 ...
1
vote
1answer
268 views
Can not 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 ...
0
votes
0answers
26 views
Aborting long running query under AG configuration [duplicate]
Currently we have a process where any query running over 2 mins (only select) in primary database participating in db mirroring is killed, running every 5 mins.
As we have moved to Availability groups ...
1
vote
1answer
65 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. ...
1
vote
1answer
57 views
Installing SSIS package outside of SSIDB catalog
I'm trying to simplify deployment of 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 ...
0
votes
1answer
61 views
Index automation job script
Our Production instance is running SQL Server 2014. There needs to be an automated Index defragmentation job that will either reorganize or rebuild the indexes based on the fragmentation level for a ...
1
vote
1answer
143 views
Why a job of dbms_job is BROKEN
I have Oracle job that uses dbms_job package. I see that it becomes BROKEN:
Select job,what,BROKEN from dba_jobs;
-------- ------------ -----------
1 statspack.snap; Y
I would like to know the ...
1
vote
0answers
40 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 ...
0
votes
3answers
271 views
SQL Server Agent & sp_send_dbmail failing on permissions
I have set up a SQL Server Agent job to call sp_send_dbmail with a very simple select on a certain table in a certain database. Within the properties > permissions of the target database, the ...
0
votes
1answer
464 views
How to reset failures count to zero when using dbms_jobs?
Is there some way to reset the failure count column to 0 in dba_jobs view? Sometimes a job fail and after fix it I need to wait the next scheduled execution, during this time I'd like to reset to 0 to ...
0
votes
0answers
31 views
Can't connect Oracle 11g2 Database to Job Scheduler Agent on client/application server
Running 11g2 database on one Linux server and installed Oracle client and job scheduler agent on separate Linux (application) server sitting next to it. The connection betweeen them worked fine for ...
1
vote
1answer
101 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 ...
-1
votes
2answers
50 views
Rebuild Indexes [duplicate]
We have a database named WSS_Us_App in our Production SQL Server 2014. In this database all of the indexes need to be rebuilt as most have a fragmentation level greater than 50%. I plan to rebuild ...
2
votes
1answer
138 views
Can't take backup to the shared folder
Need your help. My sql job is not able to take backup to the shared folder although the domain account, under which the sql agent service account is running, has full permission on that shared folder.
...
1
vote
2answers
50 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 ...
4
votes
3answers
521 views
How to prevent parallel running of SQL Agent jobs
What would be good ways to design a group of jobs such that they can never run at the same time?
I am looking for a generic concept, like a semaphore, which makes it easier to ensure that some jobs ...
0
votes
0answers
118 views
Oracle 12cR2 / ORA-02800 ORA-06512
When we run database jobs, we get the following error:
ORA-02800: Requests timed out
ORA-06512: at "SYS.DBMS_ISCHED", line 209
ORA-06512: at "SYS.DBMS_SCHEDULER", line 594
For 12 ...
2
votes
1answer
96 views
Job management: How to get the next running date by querying MSDB
Table sysjobschedules contains 2 columns next_run_date and next_run_time. With the help of sysschedules and column enable it should be easy to determine the next running date/time of a specific job.
...
0
votes
2answers
495 views
Maximum Error Count Reached
I created a maintenance plan to backup all the databases locally on a folder in E Drive.
Out of nowhere, the job is failing occasionally. sometimes the job runs successfully and sometimes sends an ...
2
votes
0answers
322 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 ...
0
votes
1answer
39 views
Report server scheduled job location
I inherited a SQL Server environment. In (database engine) SQL Server Agent are two jobs defined that apparently belong to the report server.
First and only step in the first job:
exec [ReportServer]....
0
votes
1answer
286 views
sp_update_schedule says @schedule_id does not exist
I wrote a script that reads job schedules from msdb.dbo.sysschedules and runs sp_update_schedule to change the active_start_time for a given subset of jobs. In each case, sp_update_schedule fails with ...
-1
votes
2answers
307 views
Why would a scheduled job fail in SQL Developer?
I am trying to create a scheduled job in Oracle SQL Developer that would run once a month and I am testing the Scheduler/Jobs feature where I have created a simple SQL query to test the ability to do ...
1
vote
2answers
102 views
Schedule Job to Start at Different Steps
I am working on a system that generates a number of recurring emails as parts of various jobs scheduled in SQL Server Agent. The emails contain text-based reports that are loosely associated to the ...
0
votes
0answers
50 views
Syntax error in adding a job step in Azure SQL Job Agent
I am inserting a job step in Azure Elastic job agent. This is my code:
EXEC jobs.sp_add_jobstep @job_name='Sample T-SQL',
@command=N' declare @columns varchar(max)
select @columns = stuff(( select '],[...
1
vote
1answer
270 views
Scheduling a procedure with DBMS_SCHEDULER. PLS-00103: Encountered the symbol “NULL” when expecting one of the following: ;
I can't schedule a job to run.
I made a procedure that writes CSV files and it works when I execute it.
Then I tried to make a job to schedule it:
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name =>...
0
votes
2answers
482 views
Grant an AD Group permission to edit all MSSQL Agent jobs
We have a team of people, we all log in MSSQL Server from SSMS using our Active Directory accounts, by Windows Authentication.
Our AD accounts are added to an AD group, which is used to grant all ...
1
vote
1answer
47 views
How to find the sql jobs that have not run for more than two months?
I would like to get a query to ascertain which sql jobs have not run for more than 60 days?
0
votes
1answer
29 views
Oracle 11g - Database Job About User Lock
I have an Oracle database (Oracle 11gR2) and I want to create a job. The job will trigger my procedure.
The procedure must comply with the rules I have specified below:
If a user's expiry_date value ...
-3
votes
1answer
238 views
SQL Server Integrity Check error
I’ve Implemented Ola's SQL Server Integrity Check on one of my SQL 2012 Servers and created a SQL Agent job to run it.
The job fails every time I run it, but when I run the code below manually it ...
0
votes
1answer
75 views
Oracle Enterprise Manager 13c - query used in metric
I got task - "send me the query used in this metric?"
It is related to Job with status "FAILED".
I find this failed Job but can't find with which query this metric detect this ...
0
votes
1answer
33 views
How to Capture Job Exit Code?
I'm essentially trying to find a better way to determine if my job has completed successfully before moving on to another call of the same job. I have multiple jobs which run through a parsing process ...
0
votes
1answer
102 views
Chaining remote SQL Server Agent Jobs with success/failure feedback
I have 2 Microsoft SQL Server 2014 (SP3-CU4) instances, residing on different servers.
ServerA has a linked server, pointing to ServerB\InstanceB.
Both instances have a job, and JobA triggers the ...
0
votes
2answers
2k views
ORA-01658: unable to create INITIAL extent for segment in tablespace SYSAUX; JOB_SCHEDULER is biggest occupant
DBMS_SCHEDULER is occupying all of my SYSAUX tablespace. I ran dbms_scheduler.purge_log which deleted 100 million rows from dba_scheduler_job_run_details, however v$sysaux_occupants and the data file ...
-1
votes
1answer
42 views
SQL Job runs without it schedule and renaming or deleting it causes other jobs fail
I recently migrated the SQL 2008 to SQL Server 2016. I started noticing a strange issue where one of the SQL Job is causing the failure of other jobs. This job is disabled and there is no schedule and ...
