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

Articles with tag Jobs Rss

Search for any content tagged jobs

<< Newer    Items 21 to 30 of 30   
 

Auto alert for SQL Agent jobs when they are enabled or disabled

It is often the case in large DBA teams where multiple DBAs can administer the same SQL Servers and it is not apparent to one DBA the importance of some of the jobs to another DBA. In this tip I show how you can be alerted of these changes.  Read more...
By Additional Articles 2009/08/13 | Source: MSSQLTips.com | Category: sql agent
Rating:  Rate this |   Briefcase | 3,371 reads

Advice for the Unemployed

Everyone has an opinion on the best advice to give an IT person who is unemployed and wants to get back into paid work. Phil Factor outlines what he would advise.  Read more...
By Phil Factor 2009/07/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 201 reads

Execute SQL job through batch file

This article will show you how you can execute a SQL job with one click, allowing anyone to do this. Author Divya Agrawal shows a technique to let other users run jobs that do things such as perform a backup with a batch file.  Read more...
By Divya Agrawal 2009/06/05 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 15,173 reads

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,297 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,553 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,551 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,778 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,009 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,574 reads

Job Execution System

ever want to allow people to execute jobs bot not be admins?  Read more...
By TJay Belt 2008/03/27 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 4,830 reads
<< Newer    Items 21 to 30 of 30