Page 1 of 1

Utility

Posted: 04 May 2012 7:36
by Gopikkd
How to DELETE a job scheduling table from the command line?

Utility

Posted: 10 May 2012 10:16
by Gopikkd
Thank You..

Posted: 17 May 2012 8:25
by Sobriquet
chookgate wrote:ctmpsm -SCHEDTAB -REMOVE <tablename>
Does this command remove the table from both EM and Control-M server?

Posted: 04 Jun 2012 12:15
by 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....

Posted: 08 Jun 2012 8:59
by 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...