Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag SQL Agent Rss

Search for any content tagged sql agent

<< Newer    Items 21 to 31 of 31   
 

Analyzing SQL Agent Job and Job Step History in SQL Server

You may have a number of jobs scheduled and often there is the need to analyze the data to see which jobs are taking a long time or which job steps are taking a long time. As you add more jobs and overhead to the server these times become even more critical and analyzing the data is key.  Read more...
By Additional Articles 2009/05/29 | Source: MSSQLTips.com | Category: sql agent
Rating: (not yet rated)  Rate this |   Briefcase | 3,597 reads

Database Mail and SQL Agent Mail setup by using a script

In this tip I provide a script with a few parameters that need to be setup to configure and turn on both of these features.  Read more...
By Additional Articles 2009/05/11 | Source: MSSQLTips.com | Category: sql agent
Rating:  Rate this |   Briefcase | 3,826 reads

Monitoring SQL Server Agent with Powershell

This article introduces the reader to Powershell. The application that it demonstrates is one that monitors SQL Server Agent to make sure it is running.  Read more...
By Additional Articles 2009/03/31 | Source: SQLTeam.com | Category: sql agent
Rating: (not yet rated)  Rate this |   Briefcase | 2,676 reads

Adding a UI to the Standalone SQL Agent

In a recent blog post, SQL Server expert Denny Cherry discusses adding a user interface to his Standalone SQL Agent, a replacement for the SQL Server Agent service.  Read more...
By Additional Articles 2009/03/17 | Source: SQLServerCentral.com | Category: sql agent
Rating: (not yet rated)  Rate this |   Briefcase | 1,727 reads

Managing many SQL Servers?

Here's an article from Rudy Panigas on how to more effectively manage multiple servers.  Read more...
By Rudy Panigas 2009/01/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,585 reads

Proxy Accounts in SQL Server

Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them  Read more...
By Additional Articles 2008/12/30 | Source: Database Journal | Category: proxy accounts
Rating: (not yet rated)  Rate this |   Briefcase | 3,818 reads

Creating One-Time Jobs - SQL School Video

SQL Agent is one of the handiest subsystems in SQL Server. This video shows how you can schedule a one-time job to handle something without you being there.  Read more...
By Andy Warren 2008/12/23 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 3,812 reads

How do I assign permissions to users to see SQL Agent Jobs?

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server  Read more...
By Additional Articles 2008/12/16 | Source: Builder.com | Category: security
Rating:  Rate this |   Briefcase | 3,079 reads

Scheduling Jobs in SQL Server Express - Part 2

In my previous article Scheduling Jobs in SQL Server Express we saw how to make simple job scheduling in SQL Server 2005 Express work. We limited the scheduling to one time or daily repeats. Sometimes this isn't enough. In this article we'll take a look at how to make a scheduling solution based on Service Broker worthy of the SQL Server Agent itself.  Read more...
By Additional Articles 2008/12/09 | Source: SQLTeam.com | Category: sql server express
Rating: (not yet rated)  Rate this |   Briefcase | 2,686 reads

Generate SQL Agent Job Schedule Report

I am trying to come up with a list of Job Schedules so I can make sure that my Jobs are staggered. Is there a way to query the system tables so I do not have to manually keep track of the schedules?  Read more...
By Additional Articles 2008/11/21 | Source: MSSQLTips.com | Category: sql agent
Rating:  Rate this |   Briefcase | 4,527 reads

Use Operations Manager to Monitor Your SQL Agent Jobs

Monitoring your SQL Server Agent jobs is important to ensuring that all of the automation you have created on your server is working correctly. Thomas LaRock brings us another article on Operations Manager and its integration with SQL Server.  Read more...
By Thomas LaRock 2008/09/08 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 6,994 reads
<< Newer    Items 21 to 31 of 31