Control-M EM/Desktop Clarification.

Archana · Post by **Archana** » 29 Jan 2009 7:06

Hi,
I am using Comtrol-M EM/Desktop to create a job.I specify a table name in the general panel.Will the table be created in the database that EM is using.I tried to look into the contents of the table from the database but when I try to execute the query,I get back an error that the table name i specified is an invalid object name which means that the table does not exists.

Your help is highly appreciated.

rpalmer · Post by **rpalmer** » 29 Jan 2009 1:48

The CONTROL-M/Desktop is a working copy and until you write the table to the CONTROL-M/EM it will not be defined in the Database.

Archana · Post by **Archana** » 30 Jan 2009 5:39

When I order the control-M job from the Control-M EM/Desktop,I get the below message

Write Table:
-------------
Table SampleTable1 was successfully written to CONTROL-M/EM database.

Upload and Order:
----------------------
5700 Scheduling table 'SampleTable1', Jobname 'BatchTest1'
5701 Job 'BatchTest1' ordered, memname = 'webServiceCall.bat', orderno='00000g'

The above status means that the table SampleTable1 is successfully written into the database.

But when I try to check the entries in the table,I dont find the table in the database.
Below is the query I use and te result I obtained

USE em640
GO
SELECT *
FROM SampleTable1
GO

Msg 208, Level 16, State 1, Line 1
Invalid object name 'SampleTable1'.

The EM database I am using is em640

Kindly let me know if I am missing out something

Post by **fyot** » 30 Jan 2009 9:08

Hi Archana

USE em640
GO
SELECT *
FROM SampleTable1
GO

Msg 208, Level 16, State 1, Line 1
Invalid object name 'SampleTable1'.

That is normal, you must see database poster, here is no table created by you control-m desktop.

There is a big difference between table created in the database and scheduling table created with control-m.

Your "SampleTable1" is a scheduling table to control-m and contain is stored in DEF_JOBS, DEF_TABLES, etc...

Try this :

select * from DEF_TABLES where SCHED_TABLE="SampleTable1"

Archana · Post by **Archana** » 30 Jan 2009 11:28

Thanks for your response..
I found an entry of "SampleTable1" in a table called CMS_SCHEDT in the Control M databse.

TBD76 · Post by **TBD76** » 18 Aug 2009 3:12

Hi Guys,

I have the same issue, load it contiool m svr its fine but keep getting the same error. How did you fix this issue?

Diablau · Post by **Diablau** » 18 Aug 2009 4:16

Have you wrote SYSTEM in the User daily field in the Table details option? I don't know if it will fix it, but anyways it is usefull...

TBD76 · Post by **TBD76** » 19 Aug 2009 10:58

Schoolboy error, jumped from 6.1 to 6.4 yesterday, all sorted now! GUI confused me when writing / uploading jobs. Feeling foolish!!