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

Content with tags Administration, Jobs Rss

   Items 1 to 7 of 7   
 

WMI Alerts

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

Job History

By Stuart Davies 2012/04/20 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 2,580 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 | 3,585 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 / restore
Rating: |  Discuss |   Briefcase | 1,971 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,529 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,825 reads
   Items 1 to 7 of 7   
 
Tags
sql agent (2)    
alerts (1)    
backup / restore (1)    
blogs (1)    
sql server agent (1)