Service Desk Practitioners Forum
cancel

How to clear scheduled tasks from SD 4.5 database?

mg_ITE
Super Contributor.

How to clear scheduled tasks from SD 4.5 database?

HI.

I've question.. I've in my admin interface many old informations about scheduled tasks.. I find out that I can clear (delete) this entries from my SD 4.5 database (Oracle). What permissions my SDDATA user must have to do that??

Now my user have permissions like:
CREATE USER SDDATA
IDENTIFIED BY VALUES
DEFAULT TABLESPACE SDDATA_DATA
TEMPORARY TABLESPACE SDDATA_TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 5 System Privileges for SDDATA
GRANT CREATE VIEW TO SDDATA;
GRANT CREATE TABLE TO SDDATA;
GRANT CREATE SESSION TO SDDATA;
GRANT CREATE SYNONYM TO SDDATA;
GRANT CREATE SEQUENCE TO SDDATA;
-- 3 Tablespace Quotas for SDDATA
ALTER USER SDDATA QUOTA UNLIMITED ON SDDATA_TEMP;
ALTER USER SDDATA QUOTA UNLIMITED ON SDDATA_INDEX;
ALTER USER SDDATA QUOTA UNLIMITED ON SDDATA_DATA;