Scheduler Usage

There is a SQL script example to give you exact Avtive Net from Control-EM database about one of yours Control-M Server.

declare @ctmserver varchar(15)
declare @activ varchar(20)

select @ctmserver='CTMSERVER'

select @activ="A"+ACTIVE_NET_NAME from dbo.COMM where DATA_CENTER=@ctmserver
select @activ

Result example:
A061030002_A

moi jfait juste un sp_help sur la base EM et j'ai tous les net name existants dans la base non ?? (puisque que j'ai toutes les tables...)

*********************************************************

me I just do a sp_help on the EM database and I have all existing net name's in the database, isn't it ?? (as i have all tables ....)

Hi philmalmaison,

It's not totally true.
Active Net could change if during the day you had a Gateway failure.
For the same gateway you can have another Active Net and keep in the same time all the tables created for the oldest ActiveNet.

So, when you want to build an automatic extraction without any mistakes in case of your gateway crashed, the best way must be to extract the last ActveNte crated by Control-M.

And finaly everybody are not access right to read database content directly, using SQL command.

fyot wrote:Hi philmalmaison,

It's not totally true.
Active Net could change if during the day you had a Gateway failure.
For the same gateway you can have another Active Net and keep in the same time all the tables created for the oldest ActiveNet.

So, when you want to build an automatic extraction without any mistakes in case of your gateway crashed, the best way must be to extract the last ActveNte crated by Control-M.

And finaly everybody are not access right to read database content directly, using SQL command.

what is the difference beetween doing isql or SQL and your solution to connect the database aren't you doing a select ?

Hi

I didn't say about database access using isql or sql.
I just told about SQL syntax.

ok anyway your right