Changing the task interval for PA tasks.

Changing the PA Task Interval - by command line.






First convert them to Identifiers, so that we can easily track it.

Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."TASKINT" = 120 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-6bee'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."TASKINT" = 120 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-6cf7'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."TASKINT" = 120 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-6df8'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."TASKINT" = 120 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-6efd'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."TASKINT" = 120 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-7058'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."TASKINT" = 120 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-7201'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."TASKINT" = 120 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-75d3'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."TASKINT" = 120 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-7c9f'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."TASKINT" = 120 where itmuser."KPATASKS"."ID" like '10cd562:11149a61178:-7964'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."TASKINT" = 120 where itmuser."KPATASKS"."ID" like '2716a58b:11149f27bff:-7a99'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."TASKINT" = 120 where itmuser."KPATASKS"."ID" like '346f65a6:1112b223178:-7eab'

 





Get the columns of KPATASKS:


Column name          
---------------------------
PREID                           
ISACTIVE                      
TASKINT                       
MODTYPE                    
TASKNAME                  
EXPRESSION              
UPDATETIME              
STARTUPRUN             
TASKDESC                  
ID                             

  10 record(s) selected.

The TaskDesc and Taskname are not readable elements :) . They look similar but not understandable.

  - On a side note to update all to inactive - do this.

To just update one of the tasks to 0 ( inactive )

# initially this will show '1'
select  itmuser."KPATASKS"."ID" , itmuser."KPATASKS"."ISACTIVE" from itmuser."KPATASKS"  where itmuser."KPATASKS"."ID" = '-261ac283:1112f4c4abc:-7058'

1

# update this to a 0
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 0   where itmuser."KPATASKS"."ID" = '-261ac283:1112f4c4abc:-7058'

DB20000I  The SQL command completed successfully.

# Check again  to see that it is 0
select  itmuser."KPATASKS"."ID" , itmuser."KPATASKS"."ISACTIVE" from itmuser."KPATASKS"  where itmuser."KPATASKS"."ID" = '-261ac283:1112f4c4abc:-7058'


To update all the tasks  inactive :
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 0
 

To update just the Linux agent tasks to active :

Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 1 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-6bee'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 1 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-6cf7'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 1 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-6df8'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 1 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-6efd'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 1 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-7058'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 1 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-7201'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 1 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-75d3'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 1 where itmuser."KPATASKS"."ID" like '-261ac283:1112f4c4abc:-7c9f'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 1 where itmuser."KPATASKS"."ID" like '10cd562:11149a61178:-7964'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 1 where itmuser."KPATASKS"."ID" like '2716a58b:11149f27bff:-7a99'
Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."ISACTIVE" = 1 where itmuser."KPATASKS"."ID" like '346f65a6:1112b223178:-7eab'

 
To delete all the tasks :

delete from itmuser."KPATASKS" 

will remove from the PA config panel as well as the tasks list panel in TEPS.   

To update the Task Interval ??  TASKINT to 2 minutes ( 180 secs )

select itmuser."KPATASKS"."TASKINT", itmuser."KPATASKS"."ID"  from itmuser."KPATASKS" where itmuser."KPATASKS"."ISACTIVE" = 1

# this is only for the  DiskUtilizaton  (Linux )

Update  itmuser."KPATASKS"   set  itmuser."KPATASKS"."TASKINT" = 120   where itmuser."KPATASKS"."ID" = '-261ac283:1112f4c4abc:-6efd'