Well, I am quite surprised to see that TimerLock table in SharePoint 2010 content database holds the GUID value in 'LockedBy' field. I did not get any information about it, however, as per MOSS 2007 it holds the server responsible for relaying alerts/emails
So in SharePoint 2010, LockedBy field value is replaced from holder 'ServerName' to 'Server's GUID Value'.
Question - What is the GUID value? And which server it is pointing to? I checked GUID of all web front end servers, database server, search, mail server - but this GUID is not matching with objectGUID value of any of the farm servers. What am i missing here?
Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff AT microsoft.com(Please replace AT with @)
This SharePoint Powershell command was very useful. And in fact, using this command, I am able to find out which server is actually responsible and is being used by Timer Services for alerting/emailing.
One question though, GUID determined by the PowerShell Command, what field/attribute it matched with Active Directory Objects/attributes? Does it match or it doesn't match at all?
UPDATE: Answering my own questions. GUID determined by PowerShell is retrieved from SharePoint_Config database, Objects Table. This 'Objects' table holds ID, Name and Properties fields that are very important. This objects table holds all references
being registered/used in SharePoint Server farm configuration. This GUID is not related to Active directory objectGUID at all.
This is strange case. My timer jobs (Immediate alerts and other associated with default web application) are not running at all since 08/09/2012. This is the time when unfortunately my exercise of provisioning a development machine on
my win 7 desktop got connected to production server central admin database. I finally fixed dev machine by disconnecting and making it as stand alone. looks like this overall process changed the status of my production server from WFE, also broke the timer
jobs. I have created a post explaining here http://social.msdn.microsoft.com/Forums/en/sharepoint2010setup/thread/bc7d9404-6e4a-400b-ae07-988f0dac40ba.
Any thoughts around this will help me solve this issue.