It is currently 20 Aug 2018 4:37


Post new topic  Reply to topic  [ 5 posts ] 
Author Message
PostPosted: 28 Aug 2009 4:53 
Offline
Nouveau
Nouveau
User avatar

Joined: 19 Nov 2008 12:00
Posts: 51
Location: Portland, Or. - U.S.A.
We are running Control-M 6.3 on UNIX. The COntrol-M databases are Oracle.

I need to find all jobs definitions where the DO SYSOUT is copying to anywhere but a specific directory. I could not find a way to get this from Reporting Center.

I am thinking that maybe a SQL command could be used to pull a list of jobs off the database but I have no idea what the command would look like. (I am not experienced in coding SQL.) Can anyone help?

We have several thousand job definitions and I can not spend several days manually reviewing each of them.

Thanks.


Top
   
 Post subject:
PostPosted: 31 Aug 2009 3:40 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 1148
Location: Ile de France
ok the connection command to your database could be different for oracle using sqlplus, but after logging is the same

depending of what kind of on do statment, you can find somebody in CMS_<table> representing:
SYSOUT
SHOUT
SETVAR
CON_J
REMEDY
DO
MAIL
FORCEJ

with the standard sql you can do
select <key> from <table>


regards
philmalmaison


Top
   
 Post subject:
PostPosted: 31 Aug 2009 3:42 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 1148
Location: Ile de France
for SYSOUT it could be

select JOBNO from CMS_SHOUT

tehn with JOBNO result select <what> from CMS_JOBDEF
where
JOBNO=<job>

regards
philmalmaison


Top
   
 Post subject: script the connection
PostPosted: 03 Mar 2011 4:18 
Offline
Nouveau
Nouveau
User avatar

Joined: 03 Mar 2011 12:00
Posts: 2
First of all rigjt the connection command to your database could be different for oracle using sql+, but after your logging is the samethe whole data is depending of what kind of on do statment, you can find somebody in CMS_<table> representing: then writeSYSOUTSHOUTSETVARhere are the commands u are using CON_Jand then we can usingREMEDYDOMAILFORCEwith the standard sql you can doselect key from <table>


Last edited by parkerkevin73 on 05 Mar 2011 8:03, edited 1 time in total.

Top
   
 Post subject:
PostPosted: 03 Mar 2011 8:40 
Offline
Nouveau
Nouveau
User avatar

Joined: 08 Jun 2007 12:00
Posts: 807
Location: Varese - Italy
In the version 6.3 is necessary to do a query on the DB, in the 6.4 and 7.0 there is a powerful "find and update" tool that find all you whant in all definitions fileds.

For quering the better is do the queries on the Enterprise manager DB. For example in case of version 6.3 often the db name is like em630. In fact is not recommended to do queries on the CTM-Server DB the scheduler engine.

In the EM-DB once connected you can find a table named:
DEF_DO_SYSOUT
where you can list and look for do_sysout definitions.
In this table there isnt the JOBNAME or TABLE name for example but there is jobid and tableID. You you whant in your query to see also these usefull information you must do a JOIN query....

Have a good day
MaurizioG.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 5 posts ] 

All times are UTC+02:00


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved