Search found 58 matches

by jstarkw
13 Feb 2013 4:12
Forum: Control-M Agents
Topic: ctmvar error - Request Aborted - invalid protocol used
Replies: 3
Views: 6936

Protocol error is caused by agent/server configuration. Have admin check it. Syntax for ctmvar on a windows server would be: ctmvar -ACTION SET -VAR "%%#%%#\SONYELC_D_PROGUPLD\SONYELCPROGDROPPATH" -varexpr "\\hhdhpfpapp04\HPF_Client_Files\ETAutomation\SonyElectronics\Programs\ProspectsDynam_20130207...
by jstarkw
16 Oct 2012 10:16
Forum: Control-M Enterprise Manager
Topic: Last day of month calendar
Replies: 2
Views: 3702

Thank you! So simple and works perfect.
by jstarkw
10 Oct 2012 4:38
Forum: Control-M Enterprise Manager
Topic: New Day Scan Hanging
Replies: 4
Views: 6784

Make sure you are cleaning prerequisite conditions. I run a job every day 30 minutes before newday that will remove all conditions older than 7 days. ctmcontb -DELETEFROM "*" %%TOMORROW %%TODATE In set tab: FD = %%$CALCDATE %%$ODATE +1 TD = %%$CALCDATE %%$ODATE -7 TOMORROW = %%SUBSTR %%FD 5 4 TODATE...
by jstarkw
10 Oct 2012 4:31
Forum: Control-M Enterprise Manager
Topic: Last day of month calendar
Replies: 2
Views: 3702

Last day of month calendar

Is there a way to schedule a job to run on the last day of the month without creating a custom calendar?
by jstarkw
25 Jul 2012 9:29
Forum: Job Definition
Topic: Can you error check a DO_CMD in a ctmfw rules file?
Replies: 1
Views: 5776

Can you error check a DO_CMD in a ctmfw rules file?

Hello All,

I would like to execute a script from a DO_CMD in a ctmfw rules file. Is there a way to pass a success /failure code back the the ctmfw job so the job block will turn red (fail) if the script fails?

Best Regards
by jstarkw
16 Jul 2012 6:52
Forum: Control-M Enterprise Manager
Topic: Best Platform to host Control-M On?
Replies: 5
Views: 6603

Unix or Linux for the win. Currently running 6.4.01 on Win2003. Need to reboot monthly (per BMC tech support) or gets sluggish and hangs sometimes. Also have to worry about all the microsoft security updates as company policy is to install them monthly. One day a security update will break control-m...
by jstarkw
13 Jul 2012 4:22
Forum: Control-M Enterprise Manager
Topic: PostgreSQL database backups.
Replies: 4
Views: 11736

PostgreSQL database backups.

Hi, I am preparing to migrate from control-m 6.4 to 7.0. I have the new server configured (Red Hat Linux) and have installed the software. This is the first time I will be using the postgreSQL databases. What is the best practice for backing up these databases? Should I set up scripts and do this ou...
by jstarkw
02 May 2012 4:41
Forum: Job Definition
Topic: Need month and year of the previus month in filename
Replies: 6
Views: 3975

Place the part that "chookgate" wrote in the set tab scheduling group tab.
by jstarkw
27 Apr 2012 1:44
Forum: Job Definition
Topic: Need month and year of the previus month in filename
Replies: 6
Views: 3975

If you are calling the file name on the command line you would just do this. "Berechnung_%%PARM1..xls"

If you are calling the file name in a script use %%PARM1 as a positional parameter.
by jstarkw
29 Feb 2012 1:43
Forum: Job Definition
Topic: How do you job with in condition or time.
Replies: 3
Views: 3509

Thank you both!

Great suggestions. Very big help.
by jstarkw
27 Feb 2012 2:47
Forum: Job Definition
Topic: How do you job with in condition or time.
Replies: 3
Views: 3509

How do you job with in condition or time.

I have a job that must be dependant upon its predecessor - a FW job - finishing, or if the time gets to 11:15am. That is: If the predecessor completes - start the job, or if the time is 11:15am and the predecessor has not completed - start the job. I am hoping someone has tackled this issue and can ...
by jstarkw
27 Feb 2012 2:11
Forum: Reporting
Topic: Total time taken by each job
Replies: 3
Views: 7597

Hi, I use this query to get run times. (found it on this forum a while back. :D ) select substring(TIMESTMP,1,8)as DATE,JOBNAME, cast((ELAPTIME/6000.00)as decimal(6,2)) as MINUTES from CMR_RUNINF where CMR_RUNINF.SCHEDTAB='name of scheduling group' and CMR_RUNINF.TIMESTMP > 20100601000000 order by J...
by jstarkw
11 Jan 2012 4:50
Forum: SQL Scripts
Topic: How to find out what happened to a past job?
Replies: 2
Views: 5343

Thank-you! I was able to use the IOALOG table to aid in finding the job disapeared due to another job in a completely different scheduling group having the exact same out condition as the predecessor of the job that vanished. This caused the job to run on 1/1 and be removed from the AJF on the 1/2 n...
by jstarkw
11 Jan 2012 12:11
Forum: SQL Scripts
Topic: How to find out what happened to a past job?
Replies: 2
Views: 5343

How to find out what happened to a past job?

I have a job that was ordered on 1/1 with a max wait of 20. I only keep archived viewpoints for 7 days. I keep my sysout logs for 14 days and confirmed that the job ordered on 1/1 in the udly sysout log. I can see in my archive viewpoint the job was gone on 1/3 The trigger for the job was not availa...
by jstarkw
09 Dec 2011 9:06
Forum: Control-M Agents
Topic: FW rules file when there is white space in the file path
Replies: 2
Views: 4861

Correction: "%FILENAME%"