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

Content with tag SQL Server Agent Rss

   Items 1 to 20 of 36    Older >>
 

Automating SQL Server Agent Notification

This article looks at some automated approaches of monitoring SQL Server agent jobs.  Read more...
By Additional Articles 2014/08/13 | Source: Database Journal | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 8,444 reads

Setting Up Your SQL Server Agent Correctly

It is important to set up SQL Server Agent Security on the principles of 'executing with minimum privileges’, and ensure that errors are properly logged and alerts are set up for a comprehensive range of errors. SQL Server Agent allows fine-grained control of every job step that should allow tasks to be run entirely safely even if they occasionally need special privileges.  Read more...
By Additional Articles 2014/06/13 | Source: SimpleTalk | Category: sql server agent
Rating:  Rate this |   Briefcase | 2,552 reads

Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security

Security is a confusing topic to many, especially when it comes to understanding what rights are needed to monitor and use SQL Server Agent. This article will examine the rights and roles used for SQL Server Agent, as well as the security context requirements for jobs.  Read more...
By Richard Waymire 2014/04/16 (first published: 2012/01/11) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,648 reads

SQL Server 2012 service accounts

By Dan Hess 2013/10/25 | Category: sql server 2012
Rating: (not yet rated) |  Discuss |   Briefcase | 1,943 reads

Long Running Jobs Monitor

Script to be executed every 60 minutes as a job to determine long running jobs.  Read more...
By Gregory Ferdinandsen 2013/07/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,304 reads

Trigger an Email of an SSRS Report from an SSIS Package

This article demonstrates how to trigger an SSRS subscription to email a report from an Execute SQL Task using SQL Server Agent and the ReportServer.dbo.AddEvent stored procedure.  Read more...
By Stan Kulp 2013/03/19 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 10,407 reads

Stairway to SQL Server Agent: Level 1: Setup and Overview

SQL Server Agent is a Microsoft Windows service that allows a DBA to automate administrative tasks. SQL Server Agent can run jobs, monitor SQL Server, and process alerts. The SQL Server Agent service must be running before any jobs scheduled to execute automatically can be run  Read more...
By Richard Waymire 2013/01/02 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 16,121 reads

Querying SQL Server Agent Job History Data

Often times we are tasked with having to programmatically come with a list of durations per SQL Server Agent Job to trend the run times and order the results by date. Unfortunately it's not always easy in the way the data is stored in the system tables in the MSDB database. This tip explains how to use the system tables to get the data into the correct format for dates and job durations.  Read more...
By Additional Articles 2013/01/02 | Source: MSSQLCity.com | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 3,133 reads

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.  Read more...
By Nakul Vachhrajani 2012/09/17 | Source: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,282 reads

Stairway to SQL Server Agent - Level 12: Using MSX/TSX to scale out Job Management

Examines the scale-out capabilities of SQL Server Agent, using the MSX/TSX subsystem. This capability allows you to run jobs on multiple systems and consolidate the job results/history onto a single server.  Read more...
By Richard Waymire 2012/02/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,131 reads

Stairway to SQL Server Agent - Level 11: Maintenance Plan Jobs

How maintenance plans are used as SQL Server Agent jobs to automate standard system tasks. This article will also lay out some suggested jobs that should be on virtually all SQL Server systems.  Read more...
By Richard Waymire 2012/02/15 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,021 reads

Stairway to SQL Server Agent - Level 10: Using proxy accounts with your Jobs

Examines the proxy subsystem, which allows job steps to impersonate another user account in order to perform tasks as a user other than the SQL Server Agent service account. This is especially useful when you want jobs to run as lower privileged users of your SQL Server.  Read more...
By Richard Waymire 2012/01/25 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,876 reads

Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security

Security is a confusing topic to many, especially when it comes to understanding what rights are needed to monitor and use SQL Server Agent. This article will examine the rights and roles used for SQL Server Agent, as well as the security context requirements for jobs.  Read more...
By Richard Waymire 2014/04/16 (first published: 2012/01/11) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,648 reads

Querying SQL Server Agent Job Information

Is there an easy/automated way to get information on SQL Server Agent jobs instead of connecting to each server and manually getting the information through the SSMS GUI?  Read more...
By Additional Articles 2012/01/02 | Source: MSSQLTips.com | Category: sql server agent
Rating:  Rate this |   Briefcase | 2,789 reads

Stairway to SQL Server Agent - Level 8: Using External programs with SQL Server Agent

One common usage of SQL Server Agent historically has been the ability to shell out to the operating system and run command line programs, using SQL Server Agent primarily as a job scheduler. This article will examine the pros and cons of using the SQL Server 2008 & 2008 R2 Powershell subsystem versus the CmdExec subsystem to perform tasks in the Operating System.  Read more...
By Richard Waymire 2011/12/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,744 reads

Stairway to SQL Server Agent - Level 7: Working with the SQL Server Agent Job Activity Monitor

The Job Activity Monitor is the system administration tool to run jobs, view job history, and enable/disable jobs. This article will also review some of the stored procedures run by the Job Activity Monitor that you can also use directly to do your own custom job monitoring.  Read more...
By Richard Waymire 2011/12/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,180 reads

Stairway to SQL Server Agent - Level 6: Workflow within Jobs - Drilling into Job steps

How to configure and optimize job steps. Topics such as process flow between steps, security, and more details of the job subsystems are examined.  Read more...
By Richard Waymire 2011/11/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,907 reads

Quick and Dirty DR Solution Using Robocopy

This article covers how to use robocopy with SQL Server Agent to copy database backup files to another server.  Read more...
By Scott Duncan 2011/11/07 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: |  Discuss |   Briefcase | 4,801 reads

Stairway to SQL Server Agent - Level 5: Understanding SQL Agent Error Logs

How to interpret and configure the SQL Server Agent error logs. Critical information about SQL Server Agent is sent to this error log, so knowing how to find it and how to interpret information in the log will save you valuable troubleshooting time.  Read more...
By Richard Waymire 2011/08/19 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,980 reads

Stairway to SQL Server Agent - Level 4: Configuring Database Mail

Examines the database mail system configuration in depth. You will learn how to configure database mail to work with SMTP mail systems, and get some troubleshooting tips.  Read more...
By Richard Waymire 2011/07/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,384 reads
   Items 1 to 20 of 36    Older >>
 
Tags
stairway series (11)    
jobs (5)    
administration (3)    
integration services (ssis) (2)    
backups (1)    
best practices (1)    
capture instance (1)    
change data capture (cdc) (1)    
configuration (1)    
daily (1)    
database engine (1)    
dba (1)    
disaster recovery (dr) (1)    
extract (1)    
extract, transform, load (etl) (1)    
frequency (1)    
interval (1)    
job history (1)    
log sequence number (lsn) (1)    
monitor (1)    
monthly (1)    
msdb (1)    
msdb.dbo.sysschedules (1)    
network service (1)    
nightly jobs (1)    
nt service (1)    
performance tuning (1)    
policy based management (pbm) (1)    
reporting services (ssrs) (1)    
reportserver.dbo.addevent (1)    
robocopy (1)    
schedule (1)    
service accounts (1)    
services (1)    
sql server 2005 (1)    
sql server 2012 (1)    
sysjobs (1)    
sysjobschedules (1)    
sysschedules (1)    
system tables (1)    
t-sql (1)    
video (1)    
weekly (1)