Jobs Uploaded On Control-M Server ?

Sameer · Post by **Sameer** » 05 Oct 2008 4:03

How to view which jobs are uploaded on control-m server ? i.e to find all jobs that are eligible for new day scan.

Anybody knows which table this information is stored ?

Any help in this regard is appreciated.

Thanks,
Sameer.

ranger67 · Post by **ranger67** » 06 Oct 2008 2:03

Tables are uploaded to CTM not individual jobs. Associatively, it is tables you will need to look at first. If you do not trust your EM data (last upload and user daily fields), you can view the tables which have a specific user daily using command line utilites. For example:

ctmpsm -schedtab -listtable "*" | grep SYSTEM

Once you know which tables will be evaluated at newday (i.e. the SYSYTEM userdaily), you can then look in each of the tables and see the possible jobs that might be loaded.

A simple shell command which may give want you are looking for is:

for i in `ctmpsm -schedtab -listtable "*" | grep SYSTEM | awk -F\) '{print $1}'`; do ctmpsm -schedtab -listjobs $i; done

I hope this helps.

Sameer · Post by **Sameer** » 06 Oct 2008 2:59

Thanks a lot !!!
I will try your solution.

Sameer · Post by **Sameer** » 09 Oct 2008 10:54

Thanks Skaven ..

philmalmaison · Post by **philmalmaison** » 09 Oct 2008 11:51

uploaded jobs ?
or
Jobs loaded by the new day procedure in AJF ?????????????????????????????????????????????????

regards
philmalmaison

Sameer · Post by **Sameer** » 12 Oct 2008 3:16

jobs tht are written to control-m server database.

Henk Trumpie · Post by **Henk Trumpie** » 14 Oct 2008 11:43

simple sql command for doing that:

select JOBNAME from CMR_AJF >> filename

To see how many tasks are scheduled:
select JOBNAME from CMR_AJF | wc -l

Henk