Scheduler Usage

In many many forum i read about different clean process that is executed to execute via SQL directly on the CTM database. But i want to 'organize' a list of all 'clean process'. Make your appoints as follows:

Example :

To clean message alerts
DELETE FROM ....

To clean old jobs .... what ever....
DELETE FROM ...

To update jobs. ...
UPDATE ....

there is a lot of command like this,but be carefull with API MAJ PROCESS
that can not be taken only by a insert or delete .......


regards
philmalmaison

Hi all,
Thanks for all this information. But i want to know that if I want to remove only records from the table not columns. Then What i have to do?
Drop is the command for deleting the table.
Thanks in advance.

so use the
delete from <table> where <what>
go


regards
philmalmaison