Search found 22 matches

by Henk Trumpie
18 Apr 2013 12:50
Forum: Control-M Enterprise Manager
Topic: Control-M EM Version 8.0.00 with PostGreSQL Database.
Replies: 3
Views: 5059

Hi,

Thank you for the reply.
I will try and add the line and see what happens

What is the command then to run?
psql / pgsql / SQL / em_sql

Regards
Henk
by Henk Trumpie
14 Apr 2013 1:42
Forum: Control-M Enterprise Manager
Topic: Control-M EM Version 8.0.00 with PostGreSQL Database.
Replies: 3
Views: 5059

Control-M EM Version 8.0.00 with PostGreSQL Database.

I know this might sound like a stupid question, but I really hope someone can help on this. We have a customer with Control-M EM Version 8.0.00 installed with a dedicated PostGreSQL Database on a Linux machine (Suse 11). Everything works fine except we can not seem to find what the command line COMM...
by Henk Trumpie
27 Aug 2012 9:35
Forum: Control-M Enterprise Manager
Topic: Installation of Control-M EM fails on Red Hat Linux Server 6
Replies: 5
Views: 13014

Installation of Control-M EM fails on Red Hat Linux Server 6

We experience issues around installing the product on Red Hat Linux Server 6.3 with PostGres Database. Compatibility Report on BMC site say it is fully compatible with Red Hat Linux Server 6. Running the check_req.sh script on the command line as root, selecting PostGres DB, it comes back with error...
by Henk Trumpie
28 Oct 2008 1:36
Forum: SQL Scripts
Topic: MSSQL 2000 Sequel Stored Procedure
Replies: 0
Views: 9580

MSSQL 2000 Sequel Stored Procedure

Hi there, Those of you that can help me, I would really apprciate the feedback... And no DTS commands please, for we can not use DTSRUN, or DTEXEC Control-M running sql stored procedures is a little bit on the difficult side without any intergration into sql from a Control Module or something in tha...
by Henk Trumpie
28 Oct 2008 9:53
Forum: Control-M Server
Topic: SQL Database problem
Replies: 3
Views: 4768

Hi there,

Please load the latest fix pack for 6.2.01.

This will fix your problem
by Henk Trumpie
28 Oct 2008 9:51
Forum: Job Definition
Topic: Cyclic - Check Previous Run
Replies: 5
Views: 3297

Hi there, When you specify the cyclic task, make sure that you specify the jobs to start only when the the previous one ends... This was available from the version 6.1.03 If you use cyclic to start with the parameter set as START, then you might have an over run on tasks... Make parameter END, this ...
by Henk Trumpie
24 Oct 2008 12:27
Forum: Exploitation / Operation
Topic: Extract Parameters information from Set Panel
Replies: 2
Views: 3796

Hi there, Easiest way.... On yu rControl-M/Server host, windows or unix, do the following steps: 1 - run ctmpsm 2 - Option 71 3 - Get your table name where your jobs are created in 4 - quit back to command line 4 - run ctmexdef - This is the full command: ctmexdef -TABLE "Table Name" -JOBNAME "*" -F...
by Henk Trumpie
24 Oct 2008 11:55
Forum: Control-M Server
Topic: hi / urgent
Replies: 6
Views: 7365

Hi there,

There is 2 ways of doing this...

Command Line:
Run the command called: prf
This will show you all processes of Control-M/Server that s running

ctm_menu:
option 10 - trouble shooiting
option 3 - Show process flags
by Henk Trumpie
23 Oct 2008 12:02
Forum: Control-M Server
Topic: Jobs running in other application scheduled thru control-M
Replies: 1
Views: 1295

Hi there saroj, Depending on how the tasks are running within the application, it then depends on how you can run it via Control-M... First thing always to remember is what ever you can run from a command line interface on any application, you can run from Control-M... Now, your application can have...
by Henk Trumpie
17 Oct 2008 11:07
Forum: Control-M Enterprise Manager
Topic: error with isql
Replies: 8
Views: 8394

Log into the linux with the emuser and run the root_menu command
option 1 and option 1 again and make sure that your Corba and the configuration agent is up...
If not, you wil lhave the error that it will not connect...
by Henk Trumpie
17 Oct 2008 11:01
Forum: Control-M Enterprise Manager
Topic: Jobs with Unknown status
Replies: 6
Views: 4869

Easiest way: Change your protocol version of the Control-M/Server back to 07 Change your protocol version of your Control-M/Agent from 06 to 07 and make sure you have the latest fix packs installed on the Agent... Also, use the ctmagcfg command and make the trakker process 15 second on the time inte...
by Henk Trumpie
17 Oct 2008 10:57
Forum: Exploitation / Operation
Topic: Newbie - How to return variables from Oracle SQL script
Replies: 4
Views: 3339

Hi Kenton,

If you want, please give me the wrappe around script that you have so I can have a look at it and see why you can not access parameter passing in that...

Henk Trumpie
by Henk Trumpie
14 Oct 2008 11:47
Forum: Exploitation / Operation
Topic: Newbie - How to return variables from Oracle SQL script
Replies: 4
Views: 3339

In you rdesktop, run your statement on command line:
select %1 %2 %3 from table
In your set tab, first line PARM1 with the value, then second line PARM2 and thrid line PARM3

run your task...
by Henk Trumpie
14 Oct 2008 11:43
Forum: Control-M Server
Topic: Jobs Uploaded On Control-M Server ?
Replies: 7
Views: 4406

simple sql command for doing that:

select JOBNAME from CMR_AJF >> filename

To see how many tasks are scheduled:
select JOBNAME from CMR_AJF | wc -l

Henk
by Henk Trumpie
14 Oct 2008 11:32
Forum: Monitoring
Topic: How to edit the command line for jobs in control-m
Replies: 4
Views: 3253

Hi Viky, There are diffirent ways you can do this.... Depending when you want to edit it and if it is a permanent change or not... Permanent change: Do it via your Control-M/Desptop, load your table and edit the command lines you need to edit, save it, write it back to into your EM database and then...