Eclipse Community Forums: Eclipse Process Manager (Stardust) » Resetting daemon status at the database level

Home » Archived » Eclipse Process Manager (Stardust) » Resetting daemon status at the database level(Resetting the Stardust daemons using SQL commands against the AuditTrail database)

Show: Today's Messages :: Show Polls :: Message Navigator

Resetting daemon status at the database level [message #742098]

Thu, 20 October 2011 07:03

Srinivasan Iyer

Messages: 36
Registered: October 2011

Member

The following section outlines how to turn off a daemon (event daemon, timer trigger, email trigger) that has been started for the first time using SQL commands:

The daemon_log table will show two entries per daemon type.

One entry shows, when the daemon has been initially started (code=0) and the other entry shows, when the daemon has been executed the last time (code=1).

If you want to "stop" daemons on database level, you have to execute SQL statement below.

update DAEMON_LOG set state = 0, stamp = 0 where code = 0;

This will of course not stop the daemon thread immediately, but the next time a daemon is scheduled, the daemon_log table is checked upfront. If state and stamp are set to 0, no new daemon thread will be kicked off.

[Updated on: Thu, 20 October 2011 08:27]

Report message to a moderator

Previous Topic:	Use of Timestamps in Stardust AuditTrail database
Next Topic:	How to turn on remote debugging in Tomcat 5.5?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 25 01:29:03 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter