Search found 58 matches

by jstarkw
30 Jan 2015 11:15
Forum: SQL Scripts
Topic: Report with in-condition and out-condition
Replies: 1
Views: 11496

Re: Report with in-condition and out-condition

Try this to Get jobname, in/outconditions, and cmd line. SELECT a.CONDITION AS "In Condition",c.GROUP_NAME AS "Group Name",c.JOB_NAME AS "Job name", b.CONDITION AS "Out Condition", c.CMD_LINE AS "Command Line" FROM ((DEF_VER_JOB c LEFT JOIN DEF_VER_LNKI_P a ON c.TABLE_ID = a.TABLE_ID and c.JOB_ID = ...
by jstarkw
30 Jan 2015 11:02
Forum: Job Definition
Topic: Is it possible to assign autoedit variables from sysout?
Replies: 2
Views: 4284

Re: Is it possible to assign autoedit variables from sysout?

You could add the ctmvar -action set command in the code that is running instead of trying to parse the sysout.
by jstarkw
30 Jan 2015 10:54
Forum: Control-M Enterprise Manager
Topic: Bulk By pass time dependent jobs in EM
Replies: 2
Views: 6284

Re: Bulk By pass time dependent jobs in EM

Have you tried highlighting the jobs in the tree view (Left Pane). Highlighting works the same as it does in windows explorer. Then right click on any of the highlighted jobs and select Run now? (Not sure if "Run Now" is in v7 as i use v8.)
by jstarkw
30 Jan 2015 9:54
Forum: Job Definition
Topic: Can you use CALCDATE to determine the date 3 months ago?
Replies: 2
Views: 4692

Re: Can you use CALCDATE to determine the date 3 months ago?

CALCDATE is an internal function that adds or subtracts days. I do not think you can get an exact date 3 months ago using it. -90 days does get you close.
by jstarkw
30 Jan 2015 9:47
Forum: Control-M Server
Topic: Remove BIM and Forecast in Control-mversion 8.0.4
Replies: 0
Views: 16959

Remove BIM and Forecast in Control-mversion 8.0.4

Can someone explain how to remove BIM and Forecast from control-m version 8 fixpack 4? I am finding nothing in BMC documentation.

Thanks in advance.
by jstarkw
30 Oct 2014 1:51
Forum: Exploitation / Operation
Topic: Patrol for control-m
Replies: 1
Views: 5351

Patrol for control-m

Is there anyone using patrol? What is this tool? Thanks,
by jstarkw
08 Jul 2014 8:30
Forum: Monitoring
Topic: Formating of Jobs in Version 8.0
Replies: 5
Views: 8912

Hi, EM Fixpack 3 in version 8 fixed the monitor view to be arranged more like 6.4.
by jstarkw
08 Jul 2014 8:25
Forum: Job Definition
Topic: Force OK jobs if file does not arrive.
Replies: 1
Views: 2979

Force OK jobs if file does not arrive.

Using control-m version 8 fixpack 3 Issue - Job streams are ordered but dependent upon file(s) arriving in order to run. File(s) may be deferred and not arrive. How do I force ok all jobs related to this file if it does not arrive? I do know what jobs are related to each file and they span several s...
by jstarkw
08 Jul 2014 7:30
Forum: Control-M Agents
Topic: unable to execute the job
Replies: 2
Views: 5508

Hi - You need to specify the agent name if it is not the "default" agent.

ctmfw -agent [name of agent - not servername] ctmfw S:\IBM\OutBox\VPStoreLocatorData.xml CREATE 0 60 10 3 5

Regards,
by jstarkw
08 Jul 2014 7:27
Forum: Monitoring
Topic: Using system variables in email subject
Replies: 6
Views: 11464

Can some post a working example of how autoedit variables work on a subject line of a mail. Per the 6.4 paramters guide autoedit variables can be used in: Parameters that accept AutoEdit variables AutoEdit variables can be specified as values for any of the following job processing parameters. These...
by jstarkw
02 Jul 2014 2:20
Forum: Exploitation / Operation
Topic: CONDITION vs FORCE -----Pro's and Con's ----- Discussion
Replies: 2
Views: 5580

Pros - If you have long jobstreams and some jobs that get ordered do not run on the same day. Can save on license cost by changing to force as license is calculated on the number of jobs ordered. cons - Jobs defined with the force option will order if you force order the job containing the "force". ...
by jstarkw
18 Apr 2014 9:59
Forum: Exploitation / Operation
Topic: find predessor and successor
Replies: 4
Views: 8892

Hi,

Did you replace 'application name' and 'group name' with:

c.APPLICATION='application name' and
c.GROUP_NAME='group name' and

With your actual application and group name you are using?

IE c.APPLICATION='Batch_run1' and
c.GROUP_NAME='D_run1
by jstarkw
11 Apr 2014 3:11
Forum: Exploitation / Operation
Topic: find predessor and successor
Replies: 4
Views: 8892

Hi, I wrote a mssql query that can find this info. You may need to modify if your database is Oracle or Postgres. Also written for controlm v6.4 database. Get jobname, in/outconditions, and cmd line. SELECT a.CONDITION AS "In Condition",c.GROUP_NAME AS "Group Name",c.JOB_NAME AS "Job name", b.CONDIT...
by jstarkw
07 Feb 2014 9:58
Forum: Job Definition
Topic: Schedule help needed.
Replies: 4
Views: 3783

Hi Ryan, I thought of this but the challenge here is that there are a lot of successor jobs. I am not a big fan of force order because if someone orders the scheduling table ignoring schedulng criteria, it will order the job that is supposed to get force ordered. Then you get another copy of this jo...
by jstarkw
07 Feb 2014 7:30
Forum: Job Definition
Topic: Schedule help needed.
Replies: 4
Views: 3783

P.S. Forgot to mention I am using control-m version 8.0.00.200 EM. installed on Redhat Linux.