3 Replies Latest reply on Dec 6, 2018 1:01 PM by mike.grim

    Hidden Recurring Tasks?

    mike.grim

      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?

        • Re: Hidden Recurring Tasks?
          justin.gray@weldre4.k12.co.us

          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'

          1 of 1 people found this helpful