SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Administration, Agent jobs Rss

   Items 1 to 8 of 8   

Changing Schedules

By Steve Jones 2015/08/20 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,593 reads

WMI Alerts

By Steve Jones 2014/08/08 | Category: agent jobs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,834 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 | 2,146 reads

Job History

By Stuart Davies 2012/04/20 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,670 reads

SQL Server Agent Jobs without an Operator

I work in a fairly large and unwieldy SQL Server shop. Our environment is the wild west. I have DBAs and Developers on my team that create SQL Server Agent Jobs all of the time and there is never an operator setup to email anyone based on a failure condition. I know the right solution here is to "tame the wild west" by locking down the environment and setting up a change management process, but I think that is a topic for another day. Can you give me some idea of how to identify the new recently created SQL Server Agent Jobs and Jobs without an operator setup to email us for a failure condition? I would like to receive emails when either of these conditions occur. Check out the solution to this tip to learn how.   Read more...
By Additional Articles 2011/06/03 | Source: MSSQLTips.com | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 4,371 reads

Create SQL JOB to backup database and schedule it

This script create Job and backup the database.This job backup the database.This job is scheduled for particular time.   Read more...
By Bharat Panthee 2011/01/06 | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 1,987 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,595 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: agent jobs
Rating: |  Discuss |   Briefcase | 4,843 reads
   Items 1 to 8 of 8   
sql agent (2)    
alerts (1)    
backup and restore (1)    
blogs (1)    
sql server agent (1)