SQL Agent Start Time

• chinna.sp3025

  Mr or Mrs. 500

  Points: 559

  More actions

  May 12, 2017 at 1:20 am

  #342843

  Hi Experts,

  Could you please provide me some inputs on how to get sql agent service start up time.

  Thanks in advance.

• PB_BI

  SSCoach

  Points: 17463

  More actions

  May 12, 2017 at 1:26 am

  #1942262

  chinna.sp3025 - Friday, May 12, 2017 1:20 AM

  Hi Experts,

  Could you please provide me some inputs on how to get sql agent service start up time.

  Thanks in advance.

  If you have the relevant permissions then:
  SELECT *
FROM  sys.dm_server_services
WHERE
ServiceName LIKE 'SQL Server Agent%'

  ---

  I'm on LinkedIn

• chinna.sp3025

  Mr or Mrs. 500

  Points: 559

  More actions

  May 12, 2017 at 3:27 am

  #1942289

  PB_BI - Friday, May 12, 2017 1:26 AM

  chinna.sp3025 - Friday, May 12, 2017 1:20 AM

  Hi Experts,

  Could you please provide me some inputs on how to get sql agent service start up time.

  Thanks in advance.

  If you have the relevant permissions then:
  SELECT *
FROM  sys.dm_server_services
WHERE
ServiceName LIKE 'SQL Server Agent%'

  Thank you for the reply.

  Last_startup_time showing as Null , any info on this ?

  Thanks in advace.

• PB_BI

  SSCoach

  Points: 17463

  More actions

  May 12, 2017 at 4:56 am

  #1942294

  chinna.sp3025 - Friday, May 12, 2017 3:27 AM

  PB_BI - Friday, May 12, 2017 1:26 AM

  chinna.sp3025 - Friday, May 12, 2017 1:20 AM

  Hi Experts,

  Could you please provide me some inputs on how to get sql agent service start up time.

  Thanks in advance.

  If you have the relevant permissions then:
  SELECT *
FROM  sys.dm_server_services
WHERE
ServiceName LIKE 'SQL Server Agent%'

  Thank you for the reply.

  Last_startup_time showing as Null , any info on this ?

  Thanks in advace.

  I think it was a bug in certain earlier versions, but since you have posted in the 2016 forum I thought that it would work.

  Try this:
  SELECT program_name, login_time

  FROM sys.sysprocesses

  WHERE program_name = 'SQLAgent - Generic Refresher'

  ---

  I'm on LinkedIn

• Robert Klimes

  SSCoach

  Points: 17865

  More actions

  May 12, 2017 at 7:44 am

  #1942325

  another way would be to look for agent startup in eventlog. here is a way to parse the log with powershell.
  get-eventlog -logname system -source "service control manager" -message "*SQL Server Agent*running*"

  Bob
  -----------------------------------------------------------------------------
  How to post to get the best help[/url]

• Chinnappan Balan

  SSC-Addicted

  Points: 461

  More actions

  May 12, 2017 at 8:52 am

  #1942349

  Please use below command to read the agent start time from Agent Error Log.

  EXEC master.dbo.xp_readerrorlog 0, 2, "SQLSERVERAGENT starting under"