Hi Brett At the moment the code is a bit of a mix between looking at the status and looking at the cancel or finish times, if you null out both of those fields it should be ready to run again.
Regards Scott HotWax Media http://www.hotwaxmedia.com On 3/06/2011, at 3:43 AM, Brett Palmer wrote: > I recently had to stop a service running in production. I changed the > status_id in the JOB_SANDBOX from SERVICE_PENDING and SERVICE_RUNNING to > SERVICE_FINISHED. This stopped the service from running but now I want the > service to start again. > > I've tried changing the last SERVICE_FINISHED job to SERVICE_PENDING for > this particular job but the service engine isn't picking it up. > > Does anyone have a suggestion on how I can get this running again? > > > Thanks, > > > Brett
smime.p7s
Description: S/MIME cryptographic signature
