[seam-issues] [JBoss JIRA] Created: (JBSEAM-4594) sometime fail to execute quartz asynchronous jobs due to quatz remove all the triggers and jobs from the tables when a previous job has been executed

[TAT Tat (JIRA)]

sometime fail to execute quartz asynchronous jobs due to quatz remove all the triggers and jobs from the tables when a previous job has been executed
-----------------------------------------------------------------------------------------------------------------------------------------------------

                 Key: JBSEAM-4594
                 URL: https://jira.jboss.org/jira/browse/JBSEAM-4594
             Project: Seam
          Issue Type: Bug
          Components: Async
    Affects Versions: 2.2.0.GA
         Environment: Windows server 2003, java 1.5 , jboss 4.2.3  , Ms sql server 2005, jta jdbc driver
            Reporter: TAT Tat


For example, I schedule 3 jobs using cron expression to execute on   03:00, 03:01, 0302  respectively.

At begin, there are 3 records in qrtz_cron_triggers and qrtz_job_details respectively.

When job 1 is executed at 03:00, all records on table qrtz_cron_triggers and qrtz_job_details are gone.

The rest of the jobs will never be executed, just like nothing is scheduled.

However, this is only appear on our production environments which the jboss application server is on a  machine separated from the database server.

And the application work fine on our developments which the jboss application server is on the same  machine with the database server.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira