Cancelling work units by batch number

Message boards : Server programs : Cancelling work units by batch number
Message board moderation

To post messages, you must log in.

AuthorMessage
Greg

Send message
Joined: 14 Sep 09
Posts: 1
United States
Message 27370 - Posted: 14 Sep 2009, 6:09:52 UTC

I'm guessing that this has been done before, so I thought I'd ask before recreating the wheel. Has anyone created a script that, given a batch number, cancels all unsent work units in that batch. I envision this querying the database to create a list of work units with batch=x and server_state=2, then for each work unit in the list, setting server_state=5, outcome=5, error_mask=error_mask|16, and transition_time=whatever the current time is. I'm new to mysql programming, so pointers would be very helpful. Thanks!
ID: 27370 · Report as offensive

Message boards : Server programs : Cancelling work units by batch number

Copyright © 2024 University of California.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.