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

Articles with tag SQL Agent Rss

Search for any content tagged sql agent

<< Newer    Items 21 to 27 of 27   
 

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,522 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,408 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,722 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 | 2,967 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,524 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,128 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,913 reads
<< Newer    Items 21 to 27 of 27