Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQL Agent Rss

   Items 1 to 20 of 52    Older >>
 

Stairway to SQL Server Agent

SQL Server Agent is at the heart of any live database system. The Agent has a number of uses which aren't always obvious, and so a knowledge of the system is always useful, to developers as well as DBAs. Richard Waymire provides a simple explanation of its many uses.  Read more...

retrieve SSRS report schedule info through SQL

Grabs information about what reports in SSRS are scheduled, when are they due to be sent out, report parameters and any errors in the last run etc.  Read more...
By Ibrahim Naji 2014/02/21 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 2,314 reads

List long running SQL Agent Jobs

List long running SQL Agent jobs and email out as HTML.  Read more...
By Neil Bryan 2013/10/07 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,423 reads

Monitoring job history using Reporting Services

Easily monitoring your SQL Agent job history using SSRS for concurrency, job lenght and job status.  Read more...
By Tomaz Kastrun 2013/09/05 | Source: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 6,738 reads

Ordering steps in a SQL Agent job

Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is...  Read more...
By Kenneth Fisher 2013/07/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 959 reads

Job and Step Run Checker

A script that shows you jobs and steps that have succeded or failed recently. (basically, a T-SQL version of your SSMS Job Activity Monitor)  Read more...
By Orestes Zoupanos 2013/07/05 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,061 reads

Monitoring SQL Server Agent job run times

Introduction A few months back, I was asked how long a particular nightly process took to run. It was a super...  Read more...
By Stefaans 2013/05/01 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,102 reads

Providing SQL Agent Job Log Data for Developers

As a production Database Administrator, I do not want to give Developers direct access to the SQL Server Agent job log especially for servers in the DMZ. Another problem we have is that when there is a lot of log data for a job, the default job log doesn't contain the full log detail and that makes it harder to troubleshoot. Most of all, we are trying not to use a different code set for deployment based on the environment. Basically we want to use the same methods to deploy our jobs to Development, Test and Production.   Read more...
By Additional Articles 2013/01/29 | Source: MSSQLTips.com | Category: sql agent
Rating: (not yet rated)  Rate this |   Briefcase | 1,239 reads

Check SQL Job timings

This script is useful to check how long jobs have been running.  Read more...
By Shishir Tewari 2012/09/11 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,623 reads

Be Careful Using LiteSpeed Extended Stored Procedures With SQL Agent

It’s uncommon that a SQL Server DBA needs to create a customized backup and restore routine for an application using combination of LiteSpeed extended stored procedures. However, you should be really careful when you are implementing such a solution.  Read more...
By Dewey Wu 2012/09/04 | Source: SQLServerCentral.com | Category: backup
Rating: (not yet rated) |  Discuss |   Briefcase | 171 reads

Working with SQL Agent Durations

SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some basic math, and T-SQL to tame these unruly values.  Read more...
By Kyle Neier 2012/08/23 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,765 reads

Startup Jobs

Are there things you need to make sure are running when your SQL Agent starts? Did you know that you...  Read more...
By 2012/08/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,423 reads

SQL Server Agent Proxies

By Steve Jones 2012/05/15 | Category: sql agent
Rating: (not yet rated) |  Discuss |   Briefcase | 2,242 reads

SQL Server Agent Roles

By Steve Jones 2012/03/22 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 2,331 reads

SQL Server Agent Roles

By Steve Jones 2012/02/28 | Category: sql agent
Rating: (not yet rated) |  Discuss |   Briefcase | 2,189 reads

SQL Agent Roles

By Steve Jones 2012/02/07 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 2,202 reads

TSQL function to detect SQL Agent job state

This article has a T-SQL function to detect the SQL Agent job state.  Read more...
By Bret Lowery 2012/02/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,305 reads

SQL Agent Jobs Summary

The following script can be used to determine the list of enabled SQL Agent Jobs, their start time, average run duration and next run date.  Read more...
By Smitha Reddy 2011/12/29 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,798 reads

SQL Server Agent job information

By Iulian -207023 2011/07/27 | Category: jobs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,247 reads

Get an email notification of the failed job step detail

This trigger will notify the existing email operator of the job with detailed job step information.  Read more...
By Gokhan Varol 2011/02/17 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 2,743 reads
   Items 1 to 20 of 52    Older >>
 
Tags
jobs (24)    
security (7)    
administration (4)    
blogs (4)    
monitoring (4)    
sql server 2005 (4)    
powershell (3)    
integration services (ssis) (2)    
job (2)    
job schedule (2)    
permissions (2)    
reporting services (ssrs) (2)    
scheduling (2)    
sql server 2008 (2)    
stairway series (2)    
video (2)    
alerts (1)    
backup (1)    
check (1)    
database mail (1)    
generate jobs scipts (1)    
history (1)    
job activity (1)    
job history (1)    
long running (1)    
management (1)    
operations manager (1)    
operators (1)    
oracle (1)    
proxy account (1)    
proxy accounts (1)    
restore (1)    
run (1)    
smo (1)    
sql server 2000 (1)    
sql server 7 (1)    
sql server express (1)    
step (1)    
timeline (1)    
t-sql (1)    
xpath (1)