Search found 149 matches

by nicolas_mulot
26 Aug 2010 1:42
Forum: Job Definition
Topic: Advanced Cyclic Job
Replies: 10
Views: 6701

det72004, Sorry, I don’t really get your point. The dummy will of course finish OK every time it is activated. This jobs should be only considered as a trigger and should not participate in your statistic. You can even exclude it from your display if you wish. As for your job, no one can tell you in...
by nicolas_mulot
26 Aug 2010 12:42
Forum: Job Definition
Topic: Advanced Cyclic Job
Replies: 10
Views: 6701

det72004, Dummy job do not execute and can only finish OK – you can easily check that using the “log” option, where you can see, for example: JOB STATE CHANGED TO Wait Condition DUMMY. STATUS CHANGED TO OK .. without any “submitted” or “executing” message. They are not actually jobs, but controlm ob...
by nicolas_mulot
26 Aug 2010 11:53
Forum: Job Definition
Topic: Advanced Cyclic Job
Replies: 10
Views: 6701

det72004, Of course the documentation is not so clear about the situation when the job run takes longer than the interval. If you just specify “rerun from start time”, then there are good chances that the job reruns as soon as finished (no test made) in case it takes longer than the cycle interva, s...
by nicolas_mulot
26 Aug 2010 9:00
Forum: Job Definition
Topic: I need a variable for the next month
Replies: 7
Views: 3157

Hubba, If I understand your statement: 1°) your closing job runs once a month, the 21st working day every month. 2°) your accounting application uses other jobs which use: a) the current month before the closing job has run and which should use b) the next month after the closing job has run. If thi...
by nicolas_mulot
25 Aug 2010 10:23
Forum: Control-M Enterprise Manager
Topic: Authorisation problem 6.31:
Replies: 4
Views: 1561

Tabpgr, You say that « Authorising a jobuser to run on one agent is not a problem ». Please detail the table updates you’ve done to achieve that. I didnt find no possibility to control execution of a job. Does that mean that you control the order of the job using user/owner/nodegrp combination? I ra...
by nicolas_mulot
24 Aug 2010 5:10
Forum: Job Definition
Topic: I need a variable for the next month
Replies: 7
Views: 3157

Hubba, The longest month in the year is 31 days. The fisrst of month plus a minimum of 31 day will usually fall somewhere in the beginning of the following month. The following sequence will return “09” in %%NEXT_MONTH if you run it today %%FIRST_CUR_MONTH=%%OYEAR.%%OMONTH.01 %%SOME_DATE_NEXT_MONTH=...
by nicolas_mulot
16 Aug 2010 9:17
Forum: Reporting
Topic: generating report on duplicate jobs in multiple tables
Replies: 12
Views: 11520

catchtony, I'm not familiar with that kind of Unix syntax and have no opportunity to verify it. First, I hope for you that when running the select under ctm_menu 10.13, you actually get some count which is not 0. Second, try to proceed step by step, coding the request in an input file then calling S...
by nicolas_mulot
16 Aug 2010 2:28
Forum: Control-M Server
Topic: Integrating Control-M messages into BEM
Replies: 1
Views: 2345

1°) check for the proper product name which is actually BMC PATROL KM for Control-M. product brief description available at: http://www.bmc.com/products/product-listing/790701-1559-2357.html 2°) 1- control-m/EM has been providing for ages SNMP support to route the received alerts towards an SNMP ser...
by nicolas_mulot
13 Aug 2010 5:16
Forum: Reporting
Topic: generating report on duplicate jobs in multiple tables
Replies: 12
Views: 11520

OK then , there are no chance for you to use MS/SQL. Depending on the version and the choices of your DBAs, it might be either Oracle or PostGre, more unlikely Sybase. Take any Solaris console and log as controlm user. Type the command "SQL". It should give you a prompt, where you can type anything ...
by nicolas_mulot
13 Aug 2010 3:37
Forum: Reporting
Topic: generating report on duplicate jobs in multiple tables
Replies: 12
Views: 11520

Hi, Of course you can. First you need to make up a script which executes the request you want to run. If you use MSSQL, its even simpler, since the request is a single one so you can execute the following: Isql –U<ctmdbo> -P<ctmdbopass> -S<sql> -Q”select etc..>" Depending on the SQL version, islq ha...
by nicolas_mulot
12 Aug 2010 7:00
Forum: Reporting
Topic: ctmdbspace expire
Replies: 2
Views: 2424

Hi again,

Check BMC knowledge base entry SLN000000180618
by nicolas_mulot
12 Aug 2010 4:51
Forum: Reporting
Topic: generating report on duplicate jobs in multiple tables
Replies: 12
Views: 11520

There it is (MS/SQL as usual) drop view DUPJOBS -- need the "go" below before create view go create view DUPJOBS as select count(*) as NR , JOBNAME from CMS_JOBDEF group by JOBNAME go Once the view is created, I check the duplicates: select * from DUPJOBS where NR != 1 Result: NR JOBNAME -----------...
by nicolas_mulot
12 Aug 2010 4:39
Forum: Reporting
Topic: generating report on duplicate jobs in multiple tables
Replies: 12
Views: 11520

Please clarify. Do you want to identify those jobs which are duplicate jobnames AND tasktype=command ? If so, do you want to distinguish between let's say 2 duplicates, one being a job and one being a command? If it it the request, it migh be quite complex and the siplest I can imagine is to define ...
by nicolas_mulot
12 Aug 2010 3:51
Forum: Reporting
Topic: generating report on duplicate jobs in multiple tables
Replies: 12
Views: 11520

catchtony, You may run a request which displays the duplicates and the count per single sched_table as follows: select count(*) as NR , JOBNAME+char(9)+SCHEDTAB from CMS_JOBDEF group by JOBNAME+char(9)+SCHEDTAB order by NR desc .. which gives the following result: NR ----------- --------------------...
by nicolas_mulot
12 Aug 2010 1:05
Forum: Monitoring
Topic: filtering through dynamic
Replies: 2
Views: 1652

ppraveen, If the characteristics are too different from one job to the other, why don't you define a dynamic (or static) filter wich includes all your 10 jobnames, separated by commas? Entering the 10 names the first time might be boring, but you will have to do it only once, either by defining a st...