Knowledge.ToString()

Tag: sysjobhistory

  • Get DATETIME Value From msdb.dbo.sysjobhistory

    If you ever had to work with SQL Job Agent and find out the details about run time for the job/step, you would find it difficult to convert the INT into DATETIME. Here is the quick solution. To get the start date time, use msdb.dbo.agent_datetime function available in SQL Server 2005 onwards. If you are…

    |