Search found 149 matches
- 26 Aug 2010 1:42
- Forum: Job Definition
- Topic: Advanced Cyclic Job
- Replies: 10
- Views: 8748
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...
- 26 Aug 2010 12:42
- Forum: Job Definition
- Topic: Advanced Cyclic Job
- Replies: 10
- Views: 8748
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...
- 26 Aug 2010 11:53
- Forum: Job Definition
- Topic: Advanced Cyclic Job
- Replies: 10
- Views: 8748
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...
- 26 Aug 2010 9:00
- Forum: Job Definition
- Topic: I need a variable for the next month
- Replies: 7
- Views: 5114
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...
- 25 Aug 2010 10:23
- Forum: Control-M Enterprise Manager
- Topic: Authorisation problem 6.31:
- Replies: 4
- Views: 2155
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...
- 24 Aug 2010 5:10
- Forum: Job Definition
- Topic: I need a variable for the next month
- Replies: 7
- Views: 5114
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=...
- 16 Aug 2010 9:17
- Forum: Reporting
- Topic: generating report on duplicate jobs in multiple tables
- Replies: 12
- Views: 54423
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...
- 16 Aug 2010 2:28
- Forum: Control-M Server
- Topic: Integrating Control-M messages into BEM
- Replies: 1
- Views: 3159
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...
- 13 Aug 2010 5:16
- Forum: Reporting
- Topic: generating report on duplicate jobs in multiple tables
- Replies: 12
- Views: 54423
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 ...
- 13 Aug 2010 3:37
- Forum: Reporting
- Topic: generating report on duplicate jobs in multiple tables
- Replies: 12
- Views: 54423
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...
- 12 Aug 2010 7:00
- Forum: Reporting
- Topic: ctmdbspace expire
- Replies: 2
- Views: 3245
- 12 Aug 2010 4:51
- Forum: Reporting
- Topic: generating report on duplicate jobs in multiple tables
- Replies: 12
- Views: 54423
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 -----------...
- 12 Aug 2010 4:39
- Forum: Reporting
- Topic: generating report on duplicate jobs in multiple tables
- Replies: 12
- Views: 54423
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 ...
- 12 Aug 2010 3:51
- Forum: Reporting
- Topic: generating report on duplicate jobs in multiple tables
- Replies: 12
- Views: 54423
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 ----------- --------------------...
- 12 Aug 2010 1:05
- Forum: Monitoring
- Topic: filtering through dynamic
- Replies: 2
- Views: 2654
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...