Working with SQL Agent Durations
        Posted  
        
        on SQL Server Central
        
        See other posts from SQL Server Central
        
        
        
        Published on Thu, 23 Aug 2012 06:00:00 UT
        Indexed on 
            2012/08/29
            21:46 UTC
        
        
        Read the original article
        Hit count: 282
        
Filed under: 
        SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some basic math, and T-SQL to tame these unruly values.
|  | Learn Agile Database Development Best Practices Agile database development experts Sebastian Meine and Dennis Lloyd are running day-long classes designed to complement Red Gate’s SQL in the City US tour. Classes will be held in San Francisco, Chicago, Boston and Seattle. Register Now. | 
© SQL Server Central or respective owner