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

Where is the Scheduled Tasks stored in the database??

Highlighted
Mirek_9
Occasional Contributor

Where is the Scheduled Tasks stored in the database??

Hi All,
I can not delete old Scheduled Tasks:
Administrator console -> Business Logic ->
Scheduled Tasks etc
Is possible to make it in database?
SD 4.5 SP14 SQL database
Please help me. Thanks
Mirek

6 REPLIES
George M. Meneg
Honored Contributor

Re: Where is the Scheduled Tasks stored in the database??

Hello Mirek,

You can find scheduled task in sd_userDB running the query
select * from rep_javaobjects where jav_entity = 281478464602119

But you won't be able to "decrypt" the values.

If you have scheduled tasks in the past, just restart the server. All the non valid tasks will be cleared.
menes fhtagn
Mirek_9
Occasional Contributor

Re: Where is the Scheduled Tasks stored in the database??

Hello George
Thanks for your response
I change IP address, domen etc, i restart the server and still i have old scheduled tasks with old server date.
I will check your suggestion to monday
Thanks & Regards
Mirek



HPRB
HPE Expert

Re: Where is the Scheduled Tasks stored in the database??

Hi Mirek,

The scheduled task are stored as serialised java objects in the database. To delete old scheduled task in queue run the following sql statement:
First find the number of scheduled task in queue by running select:
Select count(*) from rep_javaobjects
where jav_entity = (
select ent_oid
from ifc_entities
where ent_name = 'Scheduled Tasks');

Then run the following delete statement to delete the scheduled task from the queue:
delete from rep_javaobjects
where jav_entity = (
select ent_oid
from ifc_entities
where ent_name = 'Scheduled Tasks');

HTH,
RB

Mirek_9
Occasional Contributor

Re: Where is the Scheduled Tasks stored in the database??

Thanks Rama for suggestion.
I wants to delete two wrong tasks only, but not all. I have 1087 Scheduled tasks - wrong only two first tasks.
Thanks for assistance, at least i know where i can search date.
Thank you for your advice
Regards
Mirek
Mirek_9
Occasional Contributor

Re: Where is the Scheduled Tasks stored in the database??

Thank you very much George and Rama for your comments, it solve my problem.
Best regards
Mirek
Michael Trothe
Acclaimed Contributor

Re: Where is the Scheduled Tasks stored in the database??

Hi Mirek,

How are you. I am having the same problem you had, what did you do to fix the problem.
I found that if I do it the way listed in here it deletes all scheduled jobs.

Michael
//Add this to "OnDomLoad" event