Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Eclipse Process Manager (Stardust) » Resetting daemon status at the database level(Resetting the Stardust daemons using SQL commands against the AuditTrail database)
Resetting daemon status at the database level [message #742098] Thu, 20 October 2011 03:03
Srinivasan Iyer is currently offline Srinivasan Iyer
Messages: 36
Registered: October 2011
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 04: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:

Current Time: Sat Aug 30 12:41:19 EDT 2014

Powered by FUDForum. Page generated in 0.01937 seconds