Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [jobs]

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

3
votes
2answers
61 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
42 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
35 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
38 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
219 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
40 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
57 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
0answers
127 views

Running SSIS package as SQL Server agent job without installing Integration Services

I have set up a SQL Server agent job that runs an SSIS package stored as a File System (on a shared drive) on my SQL Server 2012 (remote) Production DB Server. I have created proxy account and am ...
0
votes
1answer
49 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
30 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
42 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
93 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
91 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
41 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
248 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
422 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
72 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
182 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
47 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
82 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
898 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
35 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
41 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
42 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
21 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
46 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 ...
0
votes
0answers
77 views

SQL Job agent get running jobs, failed and canceld jobs in same query

I have 2 queries I want to combine into one, as below. I want to build on these queries due to restrictions I have as a user against the server. I can run exec sp_help_job @execution_status (it gives ...
1
vote
2answers
663 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
87 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
107 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
550 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
74 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. ...
0
votes
0answers
129 views

Ola Hallengren's Backup solution error message after migrating to SQL 2012 using sqlcmd stops job, t

I am using Ola Hallengren's Maintenance script, and I am having an issue executing scripts. I'm getting the below error. If I reboot SQL Server Agent Services and re-ran the jobs it works fine for a ...
1
vote
0answers
140 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 ...
1
vote
1answer
232 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) ...
0
votes
2answers
2k views

T-SQL: How create job that run monthly

I already know how to schedule monthly jobs using SQL Server Agent > Jobs, I now would like to learn how to schedule such job using T-SQL. I know how to schedule a job daily at a specific time: ...
1
vote
4answers
236 views

SQL Server Agent Job - Adding Version Number

I would like to know how to add a version number to a SQL Server Agent job without using the description field, and with it being an attribute of the job. A similar question was asked at ...
0
votes
0answers
183 views

Same Domain Linked Server Login Failing

I have several SQL Server instances. All of them are setup in the same domain, and have been working for years. One of these instances serves as an aggregator for the data of the others, and a sync ...
1
vote
1answer
45 views

Number of databases on a server. Should I try to consolidate these objects together? [closed]

Background Hi, as a BI developer I create various scripts for a middle-size company (200-300 employees). These scripts are used to manipulate / aggregate / clean data from different sources and ...
0
votes
0answers
36 views

SQL Agent scheduled job under AlwaysOn run twice on failover machine [duplicate]

Has any experienced this: -SQL Agent scheduled job running over 7 years -Using AlwaysOn for last 3 years -Runs itself (?) within milliseconds but only on the 2ndary machine -SQL Agent only shows one ...
0
votes
2answers
387 views

PLS-00306 dbms_scheduler.create_job

I'm not an expert about DBMS_SCHEDULER.CREATE_JOB and i've been asked to create a job. When i run it i get these errors: ORA-06550: line2,column 2 PLS-00306: wrong number or types of arguments in ...
0
votes
0answers
222 views

Query Syntax - Sum of different values in same column

I need to write a query that will look at the SQL job run history and return the amount of times each job has failed or succeeded. To be more specific a DTSX package will go out to group of servers ...
-1
votes
1answer
64 views

DST Back up plan

Back up schedule for log backup (using Ola's scripts) as follows: Start Time - 2AM End Time - 11.59.59PM Interval - Every 15 minutes. On November 5th, all the back ups went as detailed above. ...
-2
votes
1answer
72 views

reattach database jobs to another identical schema

I have a working DB holding schema1. I needed to clone the schema1 to schema2. I did this with expdp and impdp. Everything worked fine, least when doing impdp for metadata I got the following error: ...
1
vote
1answer
270 views

Change logging level programmatically for multiple jobs

I have multiple Sql Agent jobs, with multiple steps each. For a large subset of these jobs, I want to set the logging levels to PERFORMANCE instead of BASIC - the logs are taking a lot of log space, ...
3
votes
1answer
100 views

Delete inactive users - how to prevent jobs and reports to stop working

We have several Microsoft SQL servers in our organization and the previous DBA have not performed user reviews on any of them, so some servers are filled with inactive local users. I have a script ...
1
vote
1answer
301 views

SQL Server Jobs - syspolicy_purge_history fails

The job syspolicy_purge_history fails at the 3rd step. The error that I get is the following one: Executed as user: UserABC. A job step received an error at line 1 in a PowerShell script. ...
3
votes
0answers
125 views

Change FROM in Sql Server Notification to Cell phone [closed]

We have pager notifications set up on our SQL Server for jobs that fail. However, when the notification arrives on my pager, the sender's text message number ends in a 3 digit IDENTITY column so it ...
1
vote
3answers
69 views

Full backup on failure

I have created a maintenance plan to take a full backup of all my databases every Sundays and a differential backup every day. Also, a log backup is triggered every hour. However, there is an issue ...