Search found 48 matches

by anirudhrh
25 Apr 2016 4:41
Forum: Job Definition
Topic: Control-M database job going to unknown status while executi
Replies: 0
Views: 65345

Control-M database job going to unknown status while executi

hello All we have a Control-m database job with embedded SQL query, the query is tested and running fine , but when we run the Control-M job , the job is going to unknown status. and sometimes when i restart the agent the job is back to executing and completes. but sometimes the job still remains in...
by anirudhrh
11 Jun 2015 6:22
Forum: Scripts
Topic: How to get the orderno?
Replies: 8
Views: 15545

Re: How to get the orderno?

just login as control-m user on the control-m server and type p_36 <orderid>
by anirudhrh
05 Mar 2015 7:48
Forum: Job Definition
Topic: Find jobs ran for previous month
Replies: 1
Views: 3850

Find jobs ran for previous month

Hi all ,

we have a requirement to find the job count which have executed in the previous month.
is der a query or utility through which this can be done
by anirudhrh
05 Mar 2015 7:47
Forum: Job Definition
Topic: Kill a "currently running" job
Replies: 2
Views: 4264

Re: Kill a "currently running" job

how about using the tolerance option
by anirudhrh
19 Sep 2014 9:07
Forum: SQL Scripts
Topic: Report with in-condition and out-condition
Replies: 1
Views: 11482

Report with in-condition and out-condition

Hello All,

i need a SQL query which would pull out in-conditions and out-conditions of all jobs in a table. irrespective of jobs having any one condition.

ie : If a job doesnt have out condition, i want it to show in-condition.
by anirudhrh
14 Apr 2014 8:26
Forum: Exploitation / Operation
Topic: Find Non-SAP jobs
Replies: 1
Views: 7087

Find Non-SAP jobs

hello All,

Please suggest me a query to find all the non sap jobs. thats is jobs which does not have sap tab
by anirudhrh
14 Apr 2014 8:24
Forum: Exploitation / Operation
Topic: find predessor and successor
Replies: 4
Views: 8863

When i run the belo query it shows no table exist....
by anirudhrh
11 Apr 2014 1:00
Forum: Exploitation / Operation
Topic: find predessor and successor
Replies: 4
Views: 8863

find predessor and successor

hello All,

is there any utility which can find the predecessor and successor of a job ???
by anirudhrh
21 Mar 2014 9:46
Forum: Job Definition
Topic: Extract Command line
Replies: 4
Views: 4478

hello gglau

well that was a useful point...
but here the scenario is we run this job on adhoc basic and we make modification the commandline on each run ... so I wanted the command line each time ...
by anirudhrh
18 Mar 2014 1:33
Forum: Job Definition
Topic: Extract Command line
Replies: 4
Views: 4478

Hello ,
that might not be the case always . I was looking to extract it via a auto edit variable .for example %%JOBNAME would give you the jobname of the job , similary i want the command line of the job ... not as an attachment.
by anirudhrh
17 Mar 2014 8:58
Forum: Job Definition
Topic: Extract Command line
Replies: 4
Views: 4478

Extract Command line

Hello All,

I want a job to send an email when the job completes with the command line of the job. how can i do this ??
by anirudhrh
05 Mar 2014 5:04
Forum: Control-M Enterprise Manager
Topic: Created new job but loaded in Control-M GUi
Replies: 2
Views: 4803

1.did u give a userdaily to the table in which the job is ?
2. did u schedule the job ?
3. are any constraints wrong fr example any calendar details ?
by anirudhrh
26 Feb 2014 9:04
Forum: Scripts
Topic: How to get the orderno?
Replies: 8
Views: 15545

p_36 <orderid>
by anirudhrh
25 Feb 2014 8:28
Forum: SQL Scripts
Topic: query to find failed jobs in active network ?
Replies: 7
Views: 10407

HOW ABOUT if i need jobs of specific odate?