SQL Query to check timer job lock

To check which server is taking care of running timer jobs in ShaerPoint Farm, we need to run this query on content database in SQL and we can manage this settings at manage content database in central admin.

 

select a.lockedby, b.name

 

from WSS_Content_JCES_Manfacturing.dbo.TimerLock a inner join SharePoint2013_ConfigDB_Aug30.dbo.Objects b

 

on a.lockedby = b.Id