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...

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...

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...

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...

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...

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=...

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...

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...

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 ...

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...

Hi again,

Check BMC knowledge base entry SLN000000180618

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 -----------...

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 ...

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 ----------- --------------------...

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...