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.comOn 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