run_time - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

run_time

Author

Topic

avmreddy17
Posting Yak Master

180 Posts

Posted - 2008-02-27 : 09:58:40

What does run_time represent in the sysjobshistory table.
Is it milliseconds past midnight?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-27 : 10:03:01

see this: http://sqlserver2000.databases.aspfaq.com/how-do-i-get-the-correct-date/time-from-the-msdb-sysjob-tables.html

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources