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

Content with tags Administration, SQL Server 7, Miscellaneous, Naming Standards Rss

   Items 1 to 2 of 2   
 

Managing Jobs - Part 2

Jobs are pretty basic aren't they? They are until you get a couple hundred, or a thousand. Andy continues talking about managing jobs by standardizing how you handle notifications and failures, and talks about an interesting idea to monitor jobs separately from SQL Agent. Worth reading!   Read more...
By Andy Warren 2003/02/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,336 reads

Managing Jobs - Part 1

How many jobs do you have? 10? 100? 1000? Andy makes the point that what works to manage for a small number of jobs doesn't work when that number doubles or triples (well, unless you only had 1 job to start with!). In part one of two, this article looks at ideas for using categories and naming conventions to get things under control.   Read more...
By Andy Warren 2003/01/31 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,435 reads
   Items 1 to 2 of 2   
 
Tags
configuring (2)    
database design (2)    
monitoring (2)    
programming (2)    
strategies (2)    
sql-dmo (1)    
t-sql (1)