Questions tagged [jobs]
A scheduled task managed by the database, for example using SQL Server Agent, Oracle dbms_job, or MySQL Event Scheduler.
-1
votes
1answer
28 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
27 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
37 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
228 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
54 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
35 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
57 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
97 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
113 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
59 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
83 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
74 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
33 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 ...
4
votes
1answer
102 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
260 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
124 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
0answers
56 views
Giving Access to only one SQL Agent Job
I will only need to allow a user to execute a specific sql agent job rather than be able to execute the other jobs that are there . Please advice how to accomplish this
0
votes
0answers
84 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
153 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 ...
4
votes
2answers
69 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
237 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 ...
3
votes
2answers
203 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
44 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
511 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
96 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
129 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
121 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
32 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 ...
0
votes
1answer
63 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 ...
0
votes
1answer
177 views
CmdExec Powershell Job Step Escape Double Quotes
I have a PowerShell job step I'm trying to execute and it's failing with a syntax error I believe is because I'm trying to escape double-quotes in my code. Can anyone take a look and help me with ...
1
vote
2answers
457 views
How to stop the SQL Server Agent Job Scheduler with T-SQL?
I have a job that I manually start in coordinated time periods that does a bunch of heavy lifting (mostly restoring backups and configuring for a different server)
There are several jobs scheduled to ...
0
votes
1answer
52 views
SQL job ignoring IF condition
I have a job with a few steps(that run reports information) and i added a query i wrote to the last step.
Sometimes the job fails because of factors i can not control (application issues)
and my query ...
3
votes
1answer
729 views
INSERT failed in SQL Job because of incorrect SET options 'QUOTED_IDENTIFIER'
I created a sql job to query the plan cache and get the serial plans alone and then clear it from the plan cache.
As part of step 1 in the SQL job,i filter only the serial plans and insert it into a ...
1
vote
2answers
820 views
How to find the list of SQL Server jobs using PowerShell?
I need to create Windows PowerShell Scripts that will check and list down all SQL Jobs scheduled on a given database server.
Is it possible to find out the list using PowerShell Scripts? If yes, how ...
1
vote
4answers
108 views
replace all references to a drive inside the jobs to another drive
I have a server where all my sql server backups are currently being saved to the G: drive.
Now there is no enough disk space on drive G: to keep backups for the last 5 days.
I have asked to add ...
0
votes
1answer
315 views
length of the result exceeds the > length limit (2GB) of the target large type
Getting the following error message on the Sql Server Error Log:
SQLServer Error: 599, WRITE: The length of the result exceeds the
length limit (2GB) of the target large type. [SQLSTATE 42000]
(...
0
votes
1answer
48 views
job send email to developers upon complexion and include DBAs if it fails
I have a job that sends an email to an operator (which contains a list of emails within it) upon complexion.
Some of these people that are on that list are the developers who build everything in that ...
0
votes
1answer
94 views
Even out disk i/o
We noticed that when a few of our Microsoft SQL server jobs run disk I/O goes from a background of 1-5 disk queue length to 100-700 disk queue length. The thing is the jobs only run for 1-2 minutes so ...
2
votes
1answer
914 views
How do I find a job that sends a specific email?
I had a job sending an irrelevant email to a group of users.
The title of the email was Staging -> [AUPAIR] arrivalDate trigger issue.
When I query the jobs table in the msdb database using the ...
0
votes
1answer
41 views
What's the best way to pass a variable/valuable between steps in a SQL Server job
For example, if I create a dtsx package that fills out an excel sheet, but only email it out if there is actual data?
0
votes
0answers
59 views
Is there a date modified timestamp for steps in a job on msdb?
I need to figure out which steps have been modified since the beginning of the month. I can find which jobs have been modified, but some of the jobs have 20+ steps, so knowing which specific step was ...
1
vote
1answer
65 views
Scheduled tasks in Oracle 11g
I have a scheduled task in Oracle 11g scheduled to run at 12:00 and 17:00 each day. If the first run takes more than five hours, what would happen to the second scheduled run? Would it simply be ...
0
votes
0answers
23 views
Agent Job Activity Time Last Run Not in Sync with Computer Clock
I am updating jobs in a database in preparation for log shipping. I ran a full back up and noticed in the Job Activity Monitor that the time last run is showing for the time zone I am in and not for ...
0
votes
1answer
69 views
Job Activity Monitor - Log File Viewer is showing Duration for running jobs
As you can see in Log file Viewer it has a column Duration which change for a running job.
I want to include this column in my query (from where I get jobname etc)
Any idea to make a SIMPLE script? ...
-1
votes
1answer
45 views
Job duration email
I have need to be able to generate two types of alerts:
We have a sql job which runs every 1 hour. I need an alert to let us know the time it took to complete the job
As the count for Table1 ...
1
vote
2answers
2k views
How do I get a run duration in minutes for each individual step in a single Job?
The Run_Duration in sysjobhistory of the the complete job. Is there a way to get this? [msdb].[dbo].[sysjobactivity] only has the last step.
0
votes
1answer
224 views
Job Agent sysjobhistory run_status=0 failure but which last step was a failure?
I am getting confusing results from sysJobHistory. The message can sometimes say last step was 2 but the row from instance_id says 0.
Below are some examples below when run_status=0.
Any idea how ...
1
vote
1answer
384 views
Multiple procedures to schedule jobs
I have a package named pkg_cd. In it there are 8 procedures:
pkg_cd.PRC_CD_CASEDATAENTRY;
pkg_cd.PRC_CD_DEDUP;
pkg_cd.PRC_CD_CIBIL;
pkg_cd.PRC_CD_TVR;
pkg_cd.PRC_CD_SANCTION;
pkg_cd.PRC_CD_DOWNPAY;
...
2
votes
2answers
1k views
View SQL Server Agent jobs -> MSDB roles
When attempting to view the jobs' properties in SSMS, the users would get the error execute was denied on the object sp_help_targetserver. This is a sys SP in MSDB.
The users have
...
1
vote
1answer
105 views
Measure Agent Job failure and running jobs with 'execution_status'
Considerations
I need to create a Dashboard with job failure AND running jobs.
I have a code to get run_status etc.
I am not interested in succeed jobs.
I extract failure from run_status = 0. ...
