Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » 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 07:03
Srinivasan Iyer is currently offline Srinivasan IyerFriend
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 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:

Current Time: Thu Jun 21 20:28:59 GMT 2018

Powered by FUDForum. Page generated in 0.01302 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top