Where are "reset password" emails queued?

Thanks, Michael. Our password reset emails are being delayed by nearly an hour and we're not sure if the problem is with Telligent Community or some other part of our infrastructure. Bulk emails are delayed by several hours. How do I confirm that the emails have left the Job Scheduler? I don't see anything in the Event Log or in Job Scheduler's log.txt file.

Hi Robert,

You can see in the database what jobs have been scheduled to run.  Emails are sent via a dynamic job so looking at a particular table will tell you how many are in queue.

select * from QRTZ_DYNAMIC_TRIGGERS

This SQL query will show you all the dynamic jobs scheduled to be sent.  That should help with your detective work.

Hi There,

We had a similar issue when we got some updates to exchange 2010.  When we applied the update, we began seeing duplicate emails.  After some investigation, we found the following:

Microsoft added a spam prevention technique that delays the time it takes for exchange to send the accepted message response back to the sending service.  As a result, when the Telligent task service would connect to exchange to send the message, the task service would think that exchange did not accept the message due to Telligent short timeout settings on sending mail.  The problem is that exchange did accept the message and would send it.  Since the Telligent task service though the message failed, it would leave it in the queue and send it again later.  On the second attempt it would usually make it through.  This meant that user's would get duplicate emails.

The bad news is that we couldn't resolve this problem since the timeout setting is currently hard coded into Telligent's library.  Their is currently no configuration option for this.  If there were, we could simply lengthen the time on it and it would have resolved our issue.  To work around this, we had to use an alternate mail server for sending messages that wasn't exchange. 

I know this is not your exact problem.  I just wanted to let you know you could hit it once you get all of your exchange updates in place.

Good Luck,

Just to follow up here -

I have logged a ticket internally to review email retry configurability.  It doesn't sound quite like the same issue, but it may be something else to address as well.

Any luck with querying the QRTZ_DYNAMIC_TRIGGERS table?

Thanks,

Michael Monteleone

Hi Blake and Michael,

I think something is wrong with our QRTZ_DYNAMIC_TRIGGERS table. I tried selecting the top ten records it took over five minutes to finish the query. Viewing the table properties shows that the table only has 193 rows and takes very little disk space:

Any ideas? Can I recreate the table? In case it matters, here are the first ten items:

TRIGGER_NAME    TRIGGER_GROUP    JOB_NAME    JOB_GROUP    IS_VOLATILE    DESCRIPTION    NEXT_FIRE_TIME    PREV_FIRE_TIME    PRIORITY    TRIGGER_STATE    TRIGGER_TYPE    START_TIME    END_TIME    CALENDAR_NAME    MISFIRE_INSTR    JOB_DATA
001835d7-bcf0-486e-8358-5a01b0a67cc8    DEFAULT    001835d7-bcf0-486e-8358-5a01b0a67cc8    DEFAULT    0    NULL    634728777083006842    -1    5    WAITING    SIMPLE    634728777083006842    0    NULL    0    NULL
00206947-15d5-4a67-a7ad-ac18e1eca3b1    DEFAULT    00206947-15d5-4a67-a7ad-ac18e1eca3b1    DEFAULT    0    NULL    634728777085207062    -1    5    WAITING    SIMPLE    634728742073937747    0    NULL    0    NULL
003510b7-f9a4-41a8-a3ab-fd13ee1bfc9e    DEFAULT    003510b7-f9a4-41a8-a3ab-fd13ee1bfc9e    DEFAULT    0    NULL    634728777076806222    -1    5    WAITING    SIMPLE    634728731440916052    0    NULL    0    NULL
008764b7-ca67-4430-85fa-047c6250df15    DEFAULT    008764b7-ca67-4430-85fa-047c6250df15    DEFAULT    0    NULL    634728777088167358    -1    5    WAITING    SIMPLE    634728122701993582    0    NULL    0    NULL
00e17b8a-8dde-4d06-ba5d-5fc58d91ec52    DEFAULT    00e17b8a-8dde-4d06-ba5d-5fc58d91ec52    DEFAULT    0    NULL    634728777086897231    -1    5    WAITING    SIMPLE    634728690132723080    0    NULL    0    NULL
02416b37-76f9-4f28-98c9-9001963c4d68    DEFAULT    02416b37-76f9-4f28-98c9-9001963c4d68    DEFAULT    0    NULL    634728777088257367    -1    5    WAITING    SIMPLE    634728293925821505    0    NULL    0    NULL
0374c168-d974-4b0b-a070-92304a00735e    DEFAULT    0374c168-d974-4b0b-a070-92304a00735e    DEFAULT    0    NULL    634728777081646706    -1    5    WAITING    SIMPLE    634728719061581411    0    NULL    0    NULL
03d078bc-6878-4bac-b4ea-80a4dd75ca15    DEFAULT    03d078bc-6878-4bac-b4ea-80a4dd75ca15    DEFAULT    0    NULL    634728777077036245    -1    5    WAITING    SIMPLE    634728732064230567    0    NULL    0    NULL
0406529a-722b-4cf2-b2fb-a2a158ff1dae    DEFAULT    0406529a-722b-4cf2-b2fb-a2a158ff1dae    DEFAULT    0    NULL    634728777084777019    -1    5    WAITING    SIMPLE    634728722711022375    0    NULL    0    NULL
0771b7cf-872e-4b57-8109-73159cd519b6    DEFAULT    0771b7cf-872e-4b57-8109-73159cd519b6    DEFAULT    0    NULL    634728777077586300    -1    5    WAITING    SIMPLE    634728777077586300    0    NULL    0    NULL

Okay, I also noticed that the memory footprint of the Job Scheduler is quite erratic. Within a few seconds, it jumps from 500MB to 1GB and back again. Stopping the service failed, so I ended the process and can now open the table very quickly. Within the records, I see a handful of items with TRIGGER_STATE set to COMPLETE. Would that pose a problem?

Restarting the service timed out as well, resulting in a 1053 error ("did not respond in a timely fashion"). The memory usage is not quite as high but still erratic, jumping between 500MB and 250MB. With the Job Scheduler starting up, queries to the QRTZ table are once again incredibly slow. After several minutes, the Telligent Job Scheduler Service still has a status of "Starting".

Should I open a ticket for this or continue using the forums for this problem?

And just to confirm, there are no exceptions in the exception or event logs in the app for these?  Are there any in the text log file alongside the scheduler?

It's not uncommon for the scheduler to consume lots of resources, but it would be nice to know for sure whether these were errors.

As for the expected content of the QRTZ_DYNAMIC_TRIGGERS table, I think the bigger question is looking for tasks that are not complete, as those might indicate emails that have not yet been delivered to the SMTP server.

Hi Michael,

Just to confirm:

• There are no "Mail Gateway", "Email Sent To User", "Email Template Not Found", or "Email Template Parse Error" errors/exceptions in the exceptions report from the past three weeks.
• The "Email Unable To Send" exception report only has two errors from the past four days: the first item is for a missing email address; the second item from Tuesday reports that the EmailJob background job failed after 10 tries.
• The event log shows that blog, forum, and digest emails are sent successfully, though at least half of those are sent between midnight and 6am. I do not see any log entries for password reset emails.
• The Job Scheduler does not have a log.txt file and I have not deleted any since deploying TC6 a few weeks ago.

Shouldn't I be able to query the QRTZ_DYNAMIC_TRIGGERS table without waiting several minutes for the query to complete? The last time I tried, it took 22 minutes for the query to return the first ten rows out of 190 or so. Could the background jobs also experience the same delays accessing the table?

Here is a complete snapshot of our table, taken a moment ago with 57 records. I had to stop the Job Scheduler to get this without waiting forever:

TRIGGER_NAME    TRIGGER_GROUP    JOB_NAME    JOB_GROUP    IS_VOLATILE    DESCRIPTION    NEXT_FIRE_TIME    PREV_FIRE_TIME    PRIORITY    TRIGGER_STATE    TRIGGER_TYPE    START_TIME    END_TIME    CALENDAR_NAME    MISFIRE_INSTR    JOB_DATA
079eb04d-218e-4d13-b32f-0c3f950a0c71    DEFAULT    079eb04d-218e-4d13-b32f-0c3f950a0c71    DEFAULT    0    NULL    634729622545443459    -1    5    WAITING    SIMPLE    634728974397180449    0    NULL    0    NULL
1cfac1c6-93ea-45bb-9650-6ce4da3a16a8    DEFAULT    1cfac1c6-93ea-45bb-9650-6ce4da3a16a8    DEFAULT    0    NULL    634729622546363551    -1    5    WAITING    SIMPLE    634729195702303699    0    NULL    0    NULL
1fb4fb43-dc69-492e-940a-1d08194a8e05    DEFAULT    1fb4fb43-dc69-492e-940a-1d08194a8e05    DEFAULT    0    NULL    634729622546963611    -1    5    WAITING    SIMPLE    634729589956863138    0    NULL    0    NULL
212b2033-8f12-4bef-9888-5dc3d70cb6c0    DEFAULT    212b2033-8f12-4bef-9888-5dc3d70cb6c0    DEFAULT    0    NULL    634729622545013416    -1    5    WAITING    SIMPLE    634729586537617654    0    NULL    0    NULL
226e900f-74ad-4e75-91b0-fc8245e18493    DEFAULT    226e900f-74ad-4e75-91b0-fc8245e18493    DEFAULT    0    NULL    634729622545203435    -1    5    WAITING    SIMPLE    634729147995401793    0    NULL    0    NULL
2a5ea27c-4e6a-4302-992f-47d6fc902356    DEFAULT    2a5ea27c-4e6a-4302-992f-47d6fc902356    DEFAULT    0    NULL    634729607386787853    -1    5    WAITING    SIMPLE    634729607386787853    0    NULL    0    NULL
2cb376e7-6f55-491b-b433-b708ff630d56    DEFAULT    2cb376e7-6f55-491b-b433-b708ff630d56    DEFAULT    0    NULL    634729896000000000    -1    5    WAITING    SIMPLE    634729896000000000    0    NULL    0    NULL
31897e0b-da95-4b18-adf0-d72a5acb3cd4    DEFAULT    31897e0b-da95-4b18-adf0-d72a5acb3cd4    DEFAULT    0    NULL    634729622546513566    -1    5    WAITING    SIMPLE    634729195702583727    0    NULL    0    NULL
32201942-3517-4292-b97c-6cd2b2bb1f94    DEFAULT    32201942-3517-4292-b97c-6cd2b2bb1f94    DEFAULT    0    NULL    634729616071937641    -1    5    WAITING    SIMPLE    634729616071937641    0    NULL    0    NULL
3309b19f-b774-4535-a3ad-558e6cbb49c1    DEFAULT    3309b19f-b774-4535-a3ad-558e6cbb49c1    DEFAULT    0    NULL    634729622546753590    -1    5    WAITING    SIMPLE    634729606188077982    0    NULL    0    NULL
38f61c95-ddde-4b97-b684-67beb6c3bcd5    DEFAULT    38f61c95-ddde-4b97-b684-67beb6c3bcd5    DEFAULT    0    NULL    -1    634729622544683383    5    COMPLETE    SIMPLE    634729601549347012    0    NULL    0    NULL
3d585793-02d9-41b3-950d-afe673fd1efd    DEFAULT    3d585793-02d9-41b3-950d-afe673fd1efd    DEFAULT    0    NULL    634729617891724301    -1    5    WAITING    SIMPLE    634729617891724301    0    NULL    0    NULL
3e4a8c4d-0cd8-43bf-8fec-34ec2db1c7a8    DEFAULT    3e4a8c4d-0cd8-43bf-8fec-34ec2db1c7a8    DEFAULT    0    NULL    634729622545253440    -1    5    WAITING    SIMPLE    634729163728434843    0    NULL    0    NULL
3f58a839-8496-4ef2-8359-1662f2d10bbc    DEFAULT    3f58a839-8496-4ef2-8359-1662f2d10bbc    DEFAULT    0    NULL    -1    634729622544373352    5    COMPLETE    SIMPLE    634729622544373352    0    NULL    0    NULL
41b2fe9e-0ee2-4878-baaf-a08cea69f81f    DEFAULT    41b2fe9e-0ee2-4878-baaf-a08cea69f81f    DEFAULT    0    NULL    634729622545393454    -1    5    WAITING    SIMPLE    634729243179822669    0    NULL    0    NULL
45fd1f00-feb5-4ad8-87cd-b29a0702d046    DEFAULT    45fd1f00-feb5-4ad8-87cd-b29a0702d046    DEFAULT    0    NULL    634729622546813596    -1    5    WAITING    SIMPLE    634729589956293081    0    NULL    0    NULL
5001802f-4e2b-4361-971d-6268509620da    DEFAULT    5001802f-4e2b-4361-971d-6268509620da    DEFAULT    0    NULL    634729606188598034    -1    5    WAITING    SIMPLE    634729446742470033    0    NULL    0    NULL
63495192-bc88-4e39-874b-7ce029904c38    DEFAULT    63495192-bc88-4e39-874b-7ce029904c38    DEFAULT    0    NULL    634729606188708045    -1    5    WAITING    SIMPLE    634729589957213173    0    NULL    0    NULL
652d26f9-902a-4998-a89e-c8e51dacc9ff    DEFAULT    652d26f9-902a-4998-a89e-c8e51dacc9ff    DEFAULT    0    NULL    634729606188928067    -1    5    WAITING    SIMPLE    634720787709684786    0    NULL    0    NULL
66c2ea0d-1d9b-45a0-946b-98dc1d89f44e    DEFAULT    66c2ea0d-1d9b-45a0-946b-98dc1d89f44e    DEFAULT    0    NULL    634729622546213536    -1    5    WAITING    SIMPLE    634729227126445607    0    NULL    0    NULL
67ea507b-13d1-4938-a32e-5a4901ab4dcf    DEFAULT    67ea507b-13d1-4938-a32e-5a4901ab4dcf    DEFAULT    0    NULL    634729622546903605    -1    5    WAITING    SIMPLE    634729526008387333    0    NULL    0    NULL
6acf48fa-8ca6-40cb-9f94-a24727106dc3    DEFAULT    6acf48fa-8ca6-40cb-9f94-a24727106dc3    DEFAULT    0    NULL    634729622545153430    -1    5    WAITING    SIMPLE    634729588991152977    0    NULL    0    NULL
6e282adb-0b7d-49b4-84a2-3fb513a7b1e4    DEFAULT    6e282adb-0b7d-49b4-84a2-3fb513a7b1e4    DEFAULT    0    NULL    634729622546413556    -1    5    WAITING    SIMPLE    634729494118216846    0    NULL    0    NULL
72671876-557c-4198-bbd0-d422f77259dd    DEFAULT    72671876-557c-4198-bbd0-d422f77259dd    DEFAULT    0    NULL    634729622544843399    -1    5    ACQUIRED    SIMPLE    634729585258229728    0    NULL    0    NULL
78476a8f-96b2-423c-90cf-7e803de30215    DEFAULT    78476a8f-96b2-423c-90cf-7e803de30215    DEFAULT    0    NULL    634729622545103425    -1    5    WAITING    SIMPLE    634729588521084861    0    NULL    0    NULL
80d1c1eb-2020-43f6-8bb3-f67c78b5a5c3    DEFAULT    80d1c1eb-2020-43f6-8bb3-f67c78b5a5c3    DEFAULT    0    NULL    634729606188818056    -1    5    WAITING    SIMPLE    634728958456136600    0    NULL    0    NULL
8e849066-78ea-4cd4-a56a-86e2f5bcea36    DEFAULT    8e849066-78ea-4cd4-a56a-86e2f5bcea36    DEFAULT    0    NULL    634729622545053420    -1    5    WAITING    SIMPLE    634729587822913665    0    NULL    0    NULL
900700eb-96ae-4d35-82d2-cdee0e22190d    DEFAULT    900700eb-96ae-4d35-82d2-cdee0e22190d    DEFAULT    0    NULL    634729622547273642    -1    5    WAITING    SIMPLE    634729558083636326    0    NULL    0    NULL
949e6d92-6f24-41a0-a99a-e9281fcaeea6    DEFAULT    949e6d92-6f24-41a0-a99a-e9281fcaeea6    DEFAULT    0    NULL    634729622544903405    -1    5    WAITING    SIMPLE    634729606186107785    0    NULL    0    NULL
97f88bfc-76c6-4e64-bc9a-223675750db1    DEFAULT    97f88bfc-76c6-4e64-bc9a-223675750db1    DEFAULT    0    NULL    634729622546553570    -1    5    WAITING    SIMPLE    634729526007937288    0    NULL    0    NULL
9f6854db-55ca-4e54-bbba-e6c61ed47028    DEFAULT    9f6854db-55ca-4e54-bbba-e6c61ed47028    DEFAULT    0    NULL    634729622546603575    -1    5    WAITING    SIMPLE    634729606187757950    0    NULL    0    NULL
9fb2475a-8a48-49c5-92d7-825e54bba489    DEFAULT    9fb2475a-8a48-49c5-92d7-825e54bba489    DEFAULT    0    NULL    634729606188878062    -1    5    WAITING    SIMPLE    634729446742700056    0    NULL    0    NULL
a5bd419a-88fe-4121-a7f7-68a082fa82af    DEFAULT    a5bd419a-88fe-4121-a7f7-68a082fa82af    DEFAULT    0    NULL    634729606188658040    -1    5    WAITING    SIMPLE    634729558083956358    0    NULL    0    NULL
a8adf23b-06fd-4503-9391-6695c0ed5e73    DEFAULT    a8adf23b-06fd-4503-9391-6695c0ed5e73    DEFAULT    0    NULL    634729622545903505    -1    5    WAITING    SIMPLE    634729622545903505    0    NULL    0    NULL
ab2aa4bd-04fd-4766-b1ac-c03f656fb934    DEFAULT    ab2aa4bd-04fd-4766-b1ac-c03f656fb934    DEFAULT    0    NULL    634729622545313446    -1    5    WAITING    SIMPLE    634729163728454845    0    NULL    0    NULL
abea0ae8-529d-4631-a7dd-e96e8148e85b    DEFAULT    abea0ae8-529d-4631-a7dd-e96e8148e85b    DEFAULT    0    NULL    634729622547103625    -1    5    WAITING    SIMPLE    634729558083406303    0    NULL    0    NULL
ad8b32de-1a84-439a-bf90-02072d504d81    DEFAULT    ad8b32de-1a84-439a-bf90-02072d504d81    DEFAULT    0    NULL    634729622545563471    -1    5    WAITING    SIMPLE    634729163728684868    0    NULL    0    NULL
b3987b43-3836-4fb4-ae77-a3b34d5d09b8    DEFAULT    b3987b43-3836-4fb4-ae77-a3b34d5d09b8    DEFAULT    0    NULL    634729622545603475    -1    5    WAITING    SIMPLE    634729274427496932    0    NULL    0    NULL
b9d957c8-88e9-49e6-8fc5-f8a031f43d24    DEFAULT    b9d957c8-88e9-49e6-8fc5-f8a031f43d24    DEFAULT    0    NULL    634729622546703585    -1    5    WAITING    SIMPLE    634729274427696952    0    NULL    0    NULL
c1293c20-1142-4eee-8bc5-14333e9d1591    DEFAULT    c1293c20-1142-4eee-8bc5-14333e9d1591    DEFAULT    0    NULL    634729622547803695    -1    5    WAITING    SIMPLE    634729622547803695    0    NULL    0    NULL
c1cd6f8b-11a7-43a0-9d47-c39efa431735    DEFAULT    c1cd6f8b-11a7-43a0-9d47-c39efa431735    DEFAULT    0    NULL    634729606188768051    -1    5    WAITING    SIMPLE    634729415299844298    0    NULL    0    NULL
c7251b7a-8515-4af9-95e7-01187ea075e3    DEFAULT    c7251b7a-8515-4af9-95e7-01187ea075e3    DEFAULT    0    NULL    634729622546853600    -1    5    WAITING    SIMPLE    634729589956563108    0    NULL    0    NULL
ce3f8475-dde3-40bc-bf89-1cc36b4838df    DEFAULT    ce3f8475-dde3-40bc-bf89-1cc36b4838df    DEFAULT    0    NULL    634729622544963411    -1    5    WAITING    SIMPLE    634729585613355237    0    NULL    0    NULL
d1160215-b721-4f48-b7ee-433387b2a4bf    DEFAULT    d1160215-b721-4f48-b7ee-433387b2a4bf    DEFAULT    0    NULL    634729617154917409    -1    5    WAITING    SIMPLE    634729617154917409    0    NULL    0    NULL
dd15ce65-1fad-464d-a86b-ab1710b25e6e    DEFAULT    dd15ce65-1fad-464d-a86b-ab1710b25e6e    DEFAULT    0    NULL    634729622547693684    -1    5    WAITING    SIMPLE    634729622547693684    0    NULL    0    NULL
de99bdcd-284a-4e23-b80b-8ea51b1a9400    DEFAULT    de99bdcd-284a-4e23-b80b-8ea51b1a9400    DEFAULT    0    NULL    634729625678960454    -1    5    WAITING    SIMPLE    634729625678960454    0    NULL    0    NULL
e2efda74-fd8d-45be-b0e2-783f59be4bed    DEFAULT    e2efda74-fd8d-45be-b0e2-783f59be4bed    DEFAULT    0    NULL    634729622547003615    -1    5    WAITING    SIMPLE    634729542123618599    0    NULL    0    NULL
e4ee2b7e-f9b9-4e2c-8458-505b36ef64c4    DEFAULT    e4ee2b7e-f9b9-4e2c-8458-505b36ef64c4    DEFAULT    0    NULL    634729622547223637    -1    5    WAITING    SIMPLE    634729558083546317    0    NULL    0    NULL
e5a8279d-3527-418d-a3d1-03cd0664828b    DEFAULT    e5a8279d-3527-418d-a3d1-03cd0664828b    DEFAULT    0    NULL    -1    634729622544573372    5    COMPLETE    SIMPLE    634729598106205028    0    NULL    0    NULL
e6951d0e-ed8c-4bd9-a180-6bd201734235    DEFAULT    e6951d0e-ed8c-4bd9-a180-6bd201734235    DEFAULT    0    NULL    634729622546653580    -1    5    WAITING    SIMPLE    634729606187897964    0    NULL    0    NULL
ec48f4eb-2d60-42e1-817b-314a4a9cc704    DEFAULT    ec48f4eb-2d60-42e1-817b-314a4a9cc704    DEFAULT    0    NULL    634729623749287508    -1    5    WAITING    SIMPLE    634729623749287508    0    NULL    0    NULL
f1fe926e-3364-4da5-b42c-ed0c190bc39f    DEFAULT    f1fe926e-3364-4da5-b42c-ed0c190bc39f    DEFAULT    0    NULL    634729622545503465    -1    5    WAITING    SIMPLE    634729274427156898    0    NULL    0    NULL
f4769f2e-924b-49fe-9c69-0e5b65d92ffb    DEFAULT    f4769f2e-924b-49fe-9c69-0e5b65d92ffb    DEFAULT    0    NULL    -1    634729622544743389    5    COMPLETE    SIMPLE    634729604636360394    0    NULL    0    NULL
f89dcca5-8854-4fb0-bcd0-12f74879d1ad    DEFAULT    f89dcca5-8854-4fb0-bcd0-12f74879d1ad    DEFAULT    0    NULL    634729622546463561    -1    5    WAITING    SIMPLE    634729195702403709    0    NULL    0    NULL
fb89802e-cf28-45ee-a22c-f382f5ce518a    DEFAULT    fb89802e-cf28-45ee-a22c-f382f5ce518a    DEFAULT    0    NULL    634729622546303545    -1    5    WAITING    SIMPLE    634729526007617256    0    NULL    0    NULL
fdb944a5-f6c0-49b6-b51f-85cd94623da1    DEFAULT    fdb944a5-f6c0-49b6-b51f-85cd94623da1    DEFAULT    0    NULL    634729631630919313    -1    5    WAITING    SIMPLE    634729631630919313    0    NULL    0    NULL
fdba9d41-2325-4c1d-a406-13ac358bf889    DEFAULT    fdba9d41-2325-4c1d-a406-13ac358bf889    DEFAULT    0    NULL    634729622547053620    -1    5    WAITING    SIMPLE    634729478245449824    0    NULL    0    NULL

Robert,

We'll be able to communicate more closely with you through our support team if you want to put in a support ticket but we can of course continue to offer help through the forums.  

Are all of these jobs email jobs?  This SQL query will show what job is scheduled to run, when it is supposed to start and when it's scheduled to run.  It will be able to tell us what jobs are scheduled but either taking a long time to run or never being executed.

select JOB_CLASS_NAME, TRIGGER_TYPE, START_TIME, NEXT_FIRE_TIME, j.JOB_NAME, j.JOB_DATA

from QRTZ_DYNAMIC_TRIGGERS t inner join QRTZ_DYNAMIC_JOB_DETAILS j

on t.JOB_NAME = t.JOB_NAME and t.JOB_GROUP = j.JOB_GROUP

You can PM me the results of that or send it to our support team, it will likely be a pretty big data set.

Also, can you run a SQL Profiler trace with the following parameters:

All RPC:Completed events

All SQL:BatchCompleted events

Column Filters > TextData like %QRTZ_DYNAMIC%

That way we can capture what the job scheduler is doing, to make sure it's running but also to see if it's somehow locking the tables or getting into deadlocks.

If it does turn out to be email jobs that are stuck, you can remove any Exchange interaction causing problems by installing a tool called papercut that acts as a local SMTP server and catches all emails sent to it.  It's useful for testing because it doesn't forward the emails on.  You can find it here: http://papercut.codeplex.com/.  Save your email settings in the control panel and change it to use localhost as your SMTP server.  You might have to start papercut "As Administrator" or it won't be able to listen for the emails.

If you get emails in papercut then the problem may be between Telligent Evolution and Exchange.

We'll see what we can determine and do based on the results from these steps.  Thanks!

Can you set up the local IIS SMTP server, and use it as a smart host for your exchange server?  That should work around any timeout issues you have with Exchange.

Hi Alex,

We have another web application, Moodle, running on the same server as the Telligent Job Scheduler. Moodle is pointing to the same SMTP server as the Telligent Job Scheduler and sends emails immediately in our tests. Furthermore, our Exchange expert here checked and did not see any signs that Exchange was refusing emails from the TJS; emails were sent as soon as they were received. Setting up an SMTP smart host would let us see if the emails were trickling out of the TJS, but it seems doubtful that it would provide any other benefit.