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.
Control-M EM/Desktop Clarification.
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
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
Hi Archana
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"
That is normal, you must see database poster, here is no table created by you control-m desktop.USE em640
GO
SELECT *
FROM SampleTable1
GO
Msg 208, Level 16, State 1, Line 1
Invalid object name 'SampleTable1'.
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"