Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Hidden Recurring Tasks?

We have a couple recurring tasks that create tickets monthly. They were set up by a former IT Director. We would like to adjust or delete these tasks, but nothing is showing up under Setup > Tickets > Tasks nor Setup > Processes > Action Rules.

What am I missing?

Find more posts tagged with

Accepted answers

mike.grim

They basically had me do something similar. Rather than delete the task they had me mark it as deleted in the database by setting the DELETED field for the task record to 1.

First get a list of tasks:

SELECT ID, NAME, SCHEDULED, SHARED, DELETED

FROM TASK;

Then using the ID # of the task that needs to be made inactive (update the WHERE statement):

UPDATE TASK SET DELETED = 1

WHERE ID = 2;

All comments

justin.gray

We encountered the same issue a while back and had to raise a case with support. They provided some SQL commands to clear the task out of the database.

I'll post below for reference, but please assume that it may fubar your database:

Now we have two options here, first is to delete the task as you requested, or just to update some columns on the said task in the database to make sure it will not run again.

1. TO DELETE THE TASK.

- To delete the task, we need to run at least 6 SQL queries to clear out traces of the said task from the other tables in the schema.

- Here are the SQL queries that we need to execute.

- Please note that that Ticket ID, Task ID number will vary depending on your database.

DELETE FROM HISTORY_ENTRY

WHERE JOB_TICKET_ID=2*

DELETE FROM TICKET_STATUS_TIME

WHERE TICKET_ID=2*

DELETE FROM JOB_TICKET

WHERE TASK_ELEMENT_ID=1*

DELETE FROM TASK_ELEMENT

WHERE TASK_ID=1*

DELETE FROM TASK_RUN

WHERE TASK_ID=1*

DELETE FROM TASK

WHERE NAME='whatever'

2. TO DISABLE THE TASK FROM RUNNING:

- To make sure the task will not run, we need to run 3 SQL queries.

UPDATE TASK

SET NEXT_SCHEDULED_DATE=NULL

WHERE NAME='whatever'

UPDATE TASK

SET NEXT_TRIGGER_DATE=NULL

WHERE NAME='whatever'

UPDATE TASK

SET START_DATE=NULL

WHERE NAME='whatever'

mike.grim

Thank you. I'll check in with support as I don't want to mess up the DB by accident.

I'll update this post once I connect with them.

mike.grim

They basically had me do something similar. Rather than delete the task they had me mark it as deleted in the database by setting the DELETED field for the task record to 1.

First get a list of tasks:

SELECT ID, NAME, SCHEDULED, SHARED, DELETED

FROM TASK;

Then using the ID # of the task that needs to be made inactive (update the WHERE statement):

UPDATE TASK SET DELETED = 1

WHERE ID = 2;