Utility

[Gopikkd]

How to DELETE a job scheduling table from the command line?

[Gopikkd]

Thank You..

[Sobriquet]

ctmpsm -SCHEDTAB -REMOVE <tablename>

Does this command remove the table from both EM and Control-M server?

[babu1801]

hi, chookgate,

what's the version of CTM you have?

I try to delete table with your method, but failed:
em cli -U emuser -P emuser -H edwsrvem -TABLE_DELETE edwsrvctm1 EDW_TAB_TEST Delete

I got the error msg:
Error : Too many parameters.

and, there is no TABLE_DELETE option in the command help information:
<cmd> can be one of the following:
-JOB_ORDER <CTM_name> <table_name> <job_name> <Odate>* <Wait_Odate>*
[<With_Hold>*] [<library>*]
-JOB_FORCE <CTM_name> <table_name> <job_name> <Odate>* <Wait_Odate>*
[<With_Hold>*] [<library>*]
-JOB_ORDER_INTO <CTM_name> <table_name> <job_name> <table>*
[<Duplication>*] <Odate>* <Wait_Odate>* [<With_Hold>*]
[<library>*]
-JOB_FORCE_INTO <CTM_name> <table_name> <job_name> <table>*
[<Duplication>*] <Odate>* <Wait_Odate>* [<With_Hold>*]
-SUB_TABLE_FORCE_INTO <CTM_name> <sub> <table>*
[<Duplication>*] <Odate>* <Wait_Odate>* [<With_Hold>*]
[<library>*]
-TABLE_ORDER <CTM_name> <table_name> <Odate>* <Wait_Odate>*
[<With_Hold>*] [<library>*]
-TABLE_FORCE <CTM_name> <table_name> <Odate>* <Wait_Odate>*
[<With_Hold>*] [<library>*]
-TABLE_UPLOAD <CTM_name> <table_name> [<library>*]
-TABLE_DOWNLOAD <CTM_name> <table_name> [<library>*]
-CAL_UPLOAD <CTM_name> <calendar_name>
-CAL_DOWNLOAD <CTM_name> <calendar_name>
-SUB_TABLE_DELETE <CTM_name> <sub>
-JOB_DELETE <CTM_name> <table_name> <job_name> ALL/NONE/NUMBER
-MEM_DELETE <CTM_name> <table_name> <mem_name> ALL/NONE/NUMBER [<library>*]


The version of controlm I used is 7.0....

[babu1801]

Em... I got the different where it come from..

To use -DELETE_TABLE option, the EM server must have FixPacks 3 on version 7 or above.

That's why I cannot find the option a few days ago.
After I installed fixpacks 3, it works...