Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Interval Rss

   Items 1 to 2 of 2   

Intervals and Counts - Part 1

When using SQL Server, you frequently need to work with data that represents intervals of time. For example, consider intervals representing sessions, contracts, projects, and so on. Tasks related to interval manipulation are typically quite intriguing, especially because coming up with efficient solutions isn't easy. Itzik Ben-Gan explains  Read more...
By Additional Articles 2013/08/01 | Source: SQL Server Magazine | Category: interval
Rating: (not yet rated)  Rate this |   Briefcase | 3,996 reads

SQL Server Agent Schedule Decoder

This script will break job schedules down into a readable format (msdb.dbo.sysschedules)  Read more...
By Michael Abair 2010/01/06 | Source: | Category: agent jobs
Rating: |  Discuss |   Briefcase | 1,885 reads
   Items 1 to 2 of 2   
agent jobs (1)    
daily (1)    
frequency (1)    
monthly (1)    
msdb.dbo.sysschedules (1)    
schedule (1)    
sql server agent (1)    
sysjobs (1)    
sysjobschedules (1)    
sysschedules (1)    
weekly (1)