Hi,
You can try the below query in a script
select ORDERNO,APPLGROUP,JOBNAME,STATUS,STATE,STARTRUN,ENDRUN,ORDER_TIME from CMR_AJF where STARTRUN < 'yyyymmddhhmmss' and STATE = '4'
This should help.
Search found 6 matches
- 15 Apr 2014 8:18
- Forum: SQL Scripts
- Topic: Script to report jobs that are executing for more than 12 hr
- Replies: 3
- Views: 8414
- 29 Aug 2012 5:23
- Forum: Monitoring
- Topic: Error msg in Alerts
- Replies: 5
- Views: 9914
- 20 Aug 2012 11:49
- Forum: Job Definition
- Topic: Career in Control-M
- Replies: 3
- Views: 7971
Re: Career in Control-M
Hello All, Can anyone help me out regarding the career options in control-m, as its more than one and a half years m working in an MNC company, i joined der as a fresher. but currently m bit confused like what's my future in this technology, can someone please help me out onto this...... As earlier...
- 14 Aug 2012 3:19
- Forum: Opportunités / Opportunities
- Topic: Control-M specialist position open near Munich, Germany
- Replies: 3
- Views: 11929
- 09 Oct 2009 11:47
- Forum: Exploitation / Operation
- Topic: Executables
- Replies: 1
- Views: 2013
Executables
Where can i get execuatbles to Install Control M...
- 03 Aug 2009 5:35
- Forum: Exploitation / Operation
- Topic: setup
- Replies: 2
- Views: 2843
setup
i want to setup a control m environment at my home....would like to setup on a unix platform.....with also windows installed on the laptop...please suggest how shud i go about this.....thanks in advance....