combining a query and command

All questions about Control-M jobs definitions
Post Reply
User avatar
catchtony
Nouveau
Nouveau
Posts: 50
Joined: 12 Sep 2008 12:00
Contact:

combining a query and command

Post by catchtony » 11 Nov 2010 4:20

When we get the request to cancel those jobs which run on xyz node on date xxxx/xx/xx, I run a query and then a command to verify what all jobs need to be cancelled.

Query :-

select JOBNAME from CMS_JOBDEF where NODEID like <nodeid>

Command :-

ctmrpln DJ Y <table_name> '*' <Date>


and then match for the common jobs.

Was just wondering if there is any better efficient way where we can combine these two into one or someother method ?

User avatar
catchtony
Nouveau
Nouveau
Posts: 50
Joined: 12 Sep 2008 12:00
Contact:

Post by catchtony » 12 Jul 2011 5:28

.....

Post Reply