I've checked content database;
SELECT * FROM timerlock WITH (nolock)
Then having checked the eventcache table;
SELECT * FROM eventcache WITH (nolock) WHERE EventData is not null
I've got a longlist of alerts that have not sent.
I tried accessing the server in question and following this process:
- Stop the Windows SharePoint Services Timer service
- Navigate to "C:\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config\ and delete all the .xml files - DO NOT DELETE THE cache.ini FILE!
- Open the cache.ini file in notepad and change the number value to 1 then save the file.
- Start the Windows SharePoint Services Timer service.
Unfortunately that hasn't worked.