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: 216

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.

Red Gate SQL in the City 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