Service Desk Practitioners Forum
cancel

Scheduled tasks issue

SOLVED
Go to solution
Highlighted
Akies
Outstanding Contributor.

Scheduled tasks issue

Hi,

My problem is that my DB rules are working very slow since my number of scheduled atsks are about 5500 that is creating load on the server.Can anyone tell me how can I delete my previous tasks?
I am not getting any table of scheduled atsks...

Pls help..it's urgent.

Regards,
Akhil
5 REPLIES
Ruth Porter
Acclaimed Contributor.
Solution

Re: Scheduled tasks issue

Hi there,

You can only delete scheduled tasks at the DB level (ie using SQL). I attach soem SQL which will do this but 5500 does not seem that large a number and I would suggest you look at other approaches - for example, giving Java more memory.

Hope this helps

Ruth
http://www.teamultra.net
Akies
Outstanding Contributor.

Re: Scheduled tasks issue

Hi Ruth,

Thanks a lot.I am trying to increase the java memory but I was able to increase it for 1GB RAM only.However I have 4 GB RAM available.

I am not getting any code for 4 GB RAM.Can you please help me in the same.

Regards,
Akhil
Ruth Porter
Acclaimed Contributor.

Re: Scheduled tasks issue

Hi Akhil,

This (Java memory)is not an area where I am an expert but try looking at this
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=904289

Hope this helps

Ruth
http://www.teamultra.net
Ramaprasad N
Outstanding Contributor.

Re: Scheduled tasks issue

Also, you can think of deploying/implementing multiple application servers, to make efficient use of your hardware and enhance the performance of OVSD.
Akies
Outstanding Contributor.

Re: Scheduled tasks issue

Thanks ..
I have used Ruth's query to delete scheduled tasks.

Regards,
Akhil