<p dir="ltr">There is a standard procedure which is in the TTS configuration (although perhaps not enabled) which records that it was run, and when, I think in the LASTS table (you can check that by looking in the code).</p>
<p dir="ltr">Of course, to tell you if something's running you need something else to run, to do the check.</p>
<p dir="ltr">Your problem is probably that the TTS service is supposedly running but it's not actually doing anything, so looking at the status of the service with Windows tools isn't a solution.</p>
<p dir="ltr">When I contended with this in the past I set up an SQL Server Agent job which looked at the record which the above procedure updates, and if the time was further in the past than the interval I had defined it would notify me. But you could also run a Powershell script from the Windows task scheduler or use any other tool you like which can read from the database.</p>
[ בבקשה לא לשלוח הודעות פרטיות במערכת - אני לא קורא אותן ]