Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Can a scheduled task be deleted from the scheduler?

Highlighted

Can a scheduled task be deleted from the scheduler?

Hi Folks,

I created a few new rules that are now in the list of scheduled jobs. Unfortunately I have to make some changes to the times that they are scheduled to fire.
If necessary, I would rather delete them completely than have them fire at the wrong time.
Can scheduled jobs be modified or failing that, deleted entirely?

thanks,
Denis
9 REPLIES
Piotr Gorka
Honored Contributor

Re: Can a scheduled task be deleted from the scheduler?

Scheduled jobs can not be modified. You cannot delete only selected rule (it is enhancement request ITSM006475), you can only delete all scheduled jobs from ServiceDesk database by using this SQL script

delete from rep_javaobjects
where jav_entity = (
select ent_oid
from ifc_entities
where ent_name = 'Scheduled Tasks')

I hope it help

Piotrek
pio_7@o2.pl
Ruth Porter
Honored Contributor

Re: Can a scheduled task be deleted from the scheduler?

Hi Denis

The short answer is no - you cannot modify or delete anything in the scheduled tasks queue using the client.

If you want to delete them, you can do it using some SQL which I have attached. Note that this delates ALL scheduled tasks so use with extreme caution

Regards

Ruth
http://www.teamultra.net

Re: Can a scheduled task be deleted from the scheduler?

Hi Piotrek,

Thank you for the script. "Scheduled Tasks" in your example would be the rulename I want to delete?

cheers,
Denis

Re: Can a scheduled task be deleted from the scheduler?

Hi Piotrek,

You needn't reply to my second question any more. Ruth's script is the same as your one and I see that they would both would delete all the scheduled tasks, which is something I can't do. I'll just have to allow them to age out.

cheers,
Denis

Re: Can a scheduled task be deleted from the scheduler?

Hi Ruth,

Thanks for the script. Unfortunately as I mentioned, I can't delete all the tasks.

cheers,
Denis
Jorge Castilla_
Collector

Re: Can a scheduled task be deleted from the scheduler?

Hi Dennis,

What was your solution??

Rgds,

Re: Can a scheduled task be deleted from the scheduler?

Hi Jorge,

I'm afraid I had to wait and allow the notifications to age out.

cheers,
Denis
Jorge Castilla_
Collector

Re: Can a scheduled task be deleted from the scheduler?

Ok.

Thanks for your response.
Ken Briscoe
Honored Contributor

Re: Can a scheduled task be deleted from the scheduler?

If you haven't already, we should all vote for ITSM006475 !
My email is kenilian@bigpond.com.au
//Add this to "OnDomLoad" event