Questions tagged [jobs]
A scheduled task managed by the database, for example using SQL Server Agent, Oracle dbms_job, or MySQL Event Scheduler.
315
questions
0
votes
0answers
33 views
A dbms_scheduler job is not running
I need help with debugging why a certain job is not running in Oracle with the dbms_scheduler. I have many other jobs running under the same user/schema and they work.
So, how do I start finding the ...
2
votes
1answer
54 views
Linked Server Timeout - Not Queried
I have a job that runs for multiple regions across the globe. Depending on what region is running and what time zone it's in, the job might not run. It uses GOTO to get to the end and reports that it ...
1
vote
2answers
41 views
Is it possible to query for the job schedule description?
Working on putting together a script to analyze all of the active jobs and I have nearly everything I need, but if possible I would like to be able to query for the schedules description as well. Is ...
1
vote
2answers
74 views
Find jobs that succeeded, but had steps that failed
Is it possible to find jobs that succeeded, but that had steps that failed like the desired output shows? I'm new to this side of development and I'm not sure about all of the system tables, etc. If ...
0
votes
3answers
109 views
Oracle 12c and Jobs running one hour apart after changing time for hourly use
I have an Oracle 12c database in which I have detected that the scheduled jobs are running one hour apart after the change of time on the server, checking in the database I see that the SYSTIMESTAMP ...
0
votes
1answer
39 views
SqlServer Jobs Not Running - Job Activity Monitor
I have several dozen SQL Server jobs that the Job Activity Monitor displays that do not appear to have executed.
Tools used and Version details:
Microsoft SQL Server Management Studio 12.0.6024.0
...
1
vote
0answers
59 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 ...
0
votes
1answer
28 views
Toad for Oracle: Procedures, Packages, Job, and DBMS_SCHEDULER
If I have about 10 queries which contain subqueries, would it be a best practice to contain all of them in one procedure? This script creates a small fraction of the data required for a report.
DROP ...
4
votes
1answer
212 views
Why the job's next_run_time is wrong?
I got an issue regarding job stats. So I have a job with the following schedule: Occurs every day every 5 minute(s) between 12:00:00 AM and 11:59:59 PM. Schedule will be used starting on 12/13/2017.
...
-1
votes
2answers
48 views
remove a step from sql agent jobs
I copied a bunch of jobs from an HA server to a regular server and I need to delete only the first step( checks for the primary) on these jobs not all jobs. Any suggestion?
this is the query I used to ...
0
votes
0answers
39 views
disabled job still runs
In SQL Server 2014 (currently 12.0.6205) when I disable backup jobs either manually through SSMS or through T-SQL, I am seeing that the job still runs regardless of the job's enable status. Do I need ...
1
vote
0answers
32 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 ...
0
votes
2answers
35 views
Pending changes from a finished job
I'm getting the following error:
Uncommitted changes pending for file MYTABLE in library MYLIB.
CPF325E
Cause . . . . . : Uncommitted changes are pending for file MYTABLE in library ...
0
votes
1answer
153 views
How can I run a pgAgent job every 10 second?
I have a PostgreSQL 11.3 Database. I installed pgAgent for creating jobs. Now I want to run my job every 10 second, but in GUI there is possibility to write with precision of minutes, not with ...
0
votes
1answer
32 views
Newly created jobs need to be set for failure notifications automatically
Whenever a new / existing job gets failed on an instance of SQL Server, we should recieve an email about failure notification. Please help on how we can automate it?
1
vote
1answer
185 views
Save SQL server job output results to text file
I would like to save results of the SQL job to a text file.
This is the query
SELECT sqltext.text,
req.session_id,
req.blocking_session_id,
req.cpu_time,
req.wait_type,
req.status
FROM sys....
1
vote
1answer
574 views
SQL Server transactional replication is out of sync
I have setup transactional replication in SQL Server and I am using PULL to retrieve the data from the subscriber.
Recently, I noticed that the data in my subscriber is not synced up with the ...
0
votes
1answer
94 views
Mysql 8 event scheduler timezone
im 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
So to start ...
0
votes
0answers
68 views
ORA-27369: job of type EXECUTABLE failed with exit code: There are no child processes to wait for
I have existing .bat file where i call FDSLoader64.exe on daily basis to update following tables.
FF_ADVANCED_AF
FF_ADVANCED_SAF
FF_BASIC_SAF
FF_BASIC_AF
FDSLoader64.exe is supposed to download ...
2
votes
3answers
79 views
Can a MSSQL job change its own active schedule?
I am planning a new job for MSSQL Sever 2016.
I'd like the job to run on Sunday, every 10 minutes, until it sees a confirmation record is added to a table it checks as the final step in the job. If ...
0
votes
0answers
32 views
Automatic Query from root DB to new DB
I have access to an enterprise level DB used throughout the organization with tight constraints on who can access things. It contains almost all our data. I am a user of that DB with only read rights. ...
-1
votes
1answer
109 views
SQL Job failing due to an error [closed]
I am no expert with SQL for sure but I am wondering if I could take a swing at this on my own.
I have an SQL job called "Misc Update NAV" that is scheduled to run every day at 7 am, however, when ...
1
vote
2answers
35 views
SSIS connection used based on passed value
I have an SSIS package that populates a reporting warehouse from a live and test environment.
Currently the package has each step duplicated as the source connection changes between live and test. ...
0
votes
0answers
39 views
Refresh jobs failing after diskspace increase
We're refreshing our database weekly using various jobs. After an increase of diskspace I'm running in the following error:
"Specified driver could not be loaded due to system error 126: The
...
4
votes
2answers
593 views
Start job from another SQL server instance
I have a job on an SQL 2008 server (Server A) (I know this is not ideal... That issue is being addressed). The agent runs under NT AUTHORITY\NETWORK SERVICE.
I want to add a step that runs a job that ...
1
vote
2answers
88 views
is it possible to trim the table output for a specific job?
I have a routine to save the logins and apply them on a different server , and I run this routine from a job that I have scheduled to run everyday.
On that job I have specified these 3 things:
Log ...
0
votes
0answers
382 views
Create SQL Server Agent job for stored procedure with input parameter
Could you suggest please how to create SQL Server Agent job for a stored procedure that have 1 input parameter?
The procedure is correctly created and i executed it using this code :
EXECUTE dbo....
0
votes
2answers
377 views
Triggers vs. Jobs in SQL Server
I’m designing a database with a table that automatically gets loaded with a new record every 15 seconds (each record will have a 'timestamp' field and around 50 ‘float’ fields). Each record in this ...
2
votes
1answer
240 views
Run SQL Agent Job 3 times in a Row
How do I execute SQL Agent job 3 times in a row?
We are creating Data Warehouse Project. It ETLs data from Flatfile Legacy Folder, and creates Dim and Fact tables.
SSIS Project Environment Variable (...
3
votes
1answer
529 views
How to handle failed Index Optimization (Ola Hallengren) step in SQL Azure Elastic Job Agent?
I have created a SQL maintenance job using Azure Elastic Job Agent with the following step:
EXEC jobs.sp_add_jobstep @job_name = @jobName,
@step_name = 'Optimize indexes and statistics',
@command=N'
...
1
vote
2answers
272 views
Run shell script on Oracle 11g
I have an oracle database:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
"CORE 11.2.0.1.0 Production"
TNS for Linux: Version 11.2.0.1.0 - ...
0
votes
1answer
985 views
Does SQL server log when and who enabled / disabled jobs by default?
Is there any default logging or history of when a SQL job was enabled or disabled?
0
votes
2answers
326 views
Stop long running scheduled job
I need to launch a scheduled job at 12 o'clock at night and keep this job running for a period of 8 hours. What happens now is that the job is running for more than 12 hours and I really need to avoid ...
0
votes
0answers
46 views
Ola Hallengren - Parallel Backup Jobs failing on SINGLE_USER DB - 'Database is in transition' [952]
I'm using Ola's DatabasesInParallel option for "multi-threaded" execution. Last night a db was temporarily placed into SINGLE_USER for an application-based archive process and it caused all 5 threads ...
5
votes
1answer
440 views
What's the values for the Freq_Interval column in MSDB.dbo.SysSchedules when Freq_Type is weekly and more than one day is selected in the schedule?
I'm reading up on the SysSchedules table in the Microsoft API, and am trying to incorporate using this table in a query.
In the documentation, the Freq_Interval column seems to be defined out for ...
4
votes
1answer
302 views
Why are these T-SQL jobs from different SQL Server instances executed on the same instance (AlwaysOn Availability Groups)
Recently, our blocked processes dashboard has been reporting blocked processes around the time when we do our statistic update.
The reason was quickly found: an update statistics job step (T-SQL) ...
3
votes
5answers
545 views
How to stop a job for the rest of the day after the relevant condition has been satisfied once?
I have a job that runs every 5 minutes to check an IF condition. If the condition is true, it will send an email, if not, it won’t do anything.
My problem is that once the IF condition is true, it ...
1
vote
1answer
66 views
Giving access to only one SQL Agent Job
I need to allow a user only to execute a specific Agent job, rather than be able to execute the other jobs that are there . Please advise how to accomplish this.
This user will only run a copy only ...
0
votes
0answers
152 views
how to collect the information provided by tokens in order to troubleshoot failing jobs quickly?
I was working on a way to take advantage of the SQL Server Agent Tokens and Macros because I work a lot with jobs and job steps and sometimes I have to notify different people depending on the outcome ...
0
votes
2answers
408 views
Rebuild index error: “The job was stopped prior to completion by User”
I have a rebuild index job that is set to run every night. The job used to run fine, but last night for some reason the SQL Server Agent Job was stopped. The rebuild index job was running on 9 ...
3
votes
2answers
124 views
function to check whether the current server is involved in an availability group and if so, whether it is the primary
I used to have 2 servers on an availability group, but there was a problem with one of them servers involved,while patching, and to make a long story short I removed all the databases from the ...
0
votes
1answer
905 views
How to create SQL Agent job to automatically restore a database from latest backups?
There are 3 different folders which store respectively full, differential, and log backups. Different types of backups occur in different schedules. Now I need to create a new job which will ...
2
votes
1answer
1k views
availability groups - checking for primary server - cannot call a procedure with parameters
In my servers that are involved in alwayson availability groups if there are jobs running, inside the jobs I always test whether the current server is the primary in the availability group.
So the ...
0
votes
1answer
51 views
How to format the output of this query into year…second?
I have this query that given @secs a number of seconds, it returns a table with year,months,weeks,days,hours,minutes and seconds.
take for example:
declare @secs int
select @secs = 19475298
...
1
vote
0answers
939 views
dbcc failing with Cannot continue the execution because… alwayson having a change of state event for each db
I got a job DatabaseIntegrityCheck - USER_DATABASES, failing with the following error:
Date and time: 2018-10-29 02:34:13 Command: DBCC CHECKDB ([one of my
databases]) WITH NO_INFOMSGS, ...
1
vote
0answers
154 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 ...
0
votes
1answer
555 views
Why do we need to use proxies for syadmin job steps?
I read somewhere that for non-TSQL SQL Server Agent jobs, the job runs under SQL Server Service Agent account when the job owner is the sysadmin.
I just don't get why we need to use proxies even the ...
0
votes
1answer
230 views
Log shipping - Job schedules
When we configure the Log Shipping, there are jobs automatically created that run on schedule. What happens if db size grows or there is network latency, does SQL Server auto handle the job schedules? ...
2
votes
1answer
33 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 ...
1
vote
1answer
140 views
ORA-24155 - Why am I getting this error when creating a chain rule
When trying to create a new chain rule, I receive ORA-24155 stating that the the rule I'm trying to create is not in the ruleset which doesn't make sense.
I stop and drop all jobs/chains and then ...
