Hi fyot

I have now resolved the issue. I made the mistake of commenting out the loopback address in the /etc/hosts file.

Thanks for all your help, if it was not for you, I would be still messing about with ports numbers

rgd's

Hi Fyot

I found the following line in my hosts file on my redhat box:

::1 localhost6.localdomain6 localhost6

should I comment this out?

rgd's

Hi Guys

Silly question time!

How do I shutdown the controlM/server database

rgd's

Hi fyot

Thanks for your response. I have disable the firewall on both machines and I can ping both machines using the hostname and IP address. I have feeling it could be something to do with ports

Hi I have just installed Control-M/Server 7.00 on a Redhat linux 5.7 machine. When I try to discover the Control-M/Server and gateway I get the following errors: 1. Control-M/Server State=Down Desired State=Up 2. Gateway State=Up Desired State=Up Message=Disconnected Could you please advise how I ca...

Guys It seems that CTRL-M is stripping out %2 from the SQL that should be run and therefore it cannot resolve the correct exit criteria. In this case it should return a 0. We're not sure why CTRL-M would be doing this? The CTRL-M command is to run:- osql.exe -d thinkfolio_TST1 -E -S mg1vdbaz06 -n -Q...

You will need access to cmprd database to run the following script that will give you start time, end time and duration of a job you will only need to change the following below to fit your enviroment where timestmp like '20130513%' AND SCHEDTAB LIKE 'PIPR%' select distinct JOBNAME, schedtab , to_ch...

Check their user Authorizations under the Privileges tab. Make sure Archive Viewpoint tab is set to full

Hi Guys

We have two enviroments, Development and Production. Is it possible to allow users to load Development tables into the Enterprise Manager GUI,
but not be able to load tables into Production?
We are running version 7.00.00

rgd's

Hi Phil

I am using PL/SQL Developer to run the query and all I get is the column headings when I execute, but no data

rgd's

Norman

I have created this query to report the start, end and duration of a group of jobs on a daily basis. When I run the query I get no output. Could someone please check and advise. I am running version 6.04 select distinct JOBNAME, schedtab , to_char(to_timestamp(trim(timestmp) , 'YYYYMMDDHH24MISS') - ...

I use the following command on the emprd database

select username, userfullname, passexpiredate from generalauthorizations
order by passexpiredate

I use this query to see when a user last reset his/her password.

Running controlM 6.4

rgd's

Norman

Hi I use the following SQL query. We probably need the the help of a DBA to set up. select distinct JOBNAME, schedtab , to_char(to_timestamp(trim(timestmp) , 'YYYYMMDDHH24MISS') - numtodsinterval(elaptime / 100 , 'SECOND'), 'YYYY-MM-DD HH24:MI:SS') as start_time , to_char(to_date(trim(timestmp), 'YY...

Hi Guys

Is there a way I can delay a cyclic job, while a reboot takes place, and resume the job after reboot completes.

Running version 6.02.1 on Solaris

thanks in advance

Norman

Hi

Is it possible to the following, using version 6.2.01

If an event is still running at a certain time, is it possible to force the event OK and delete it's out condition?

Thanks in advance

nbarr007