|Resetting daemon status at the database level [message #742098]
||Thu, 20 October 2011 07:03
| Srinivasan Iyer
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
Powered by FUDForum
. Page generated in 0.01811 seconds