Hello everyone,
I just found this forum and I find it amazing! I'm new to Control-M but I hope to improve my knowledge by reading all the usefull information in here.
Can someone tell me if there is some way to export all Control-M jobs via SQL command (as we can do in Control-M Desktop by exporting all jobs to a csv file) ?
Thanks for your attention
Regards,
--
Y-a-t'il un moyen d'exporter via une requête/commande SQL la liste de tous les jobs Control-M (du genre export vers fichier csv sous Control-M Desktop) ?
Merci d'avance
Cordialement,
Export all Control-M jobs via SQL command
- rahulsehgal
- Nouveau
- Posts: 148
- Joined: 19 Mar 2009 12:00
- Location: Delhi
- Contact:
- philmalmaison
- Nouveau
- Posts: 1148
- Joined: 08 Jun 2007 12:00
- Location: Ile de France
no you must use the controlm em server to do it, so you have all concerned tables even if they're not upload in controlm server.
do a list of tables in EM SERVER like:
isql -U <emuser> -P <empassword> <<EOF> liste_tables.out
select SCHED_TABLE from DEF_TABLES
where
DATA_CENTER = "datacenter name"
go
EOF
and after removing headers and count row (just living tables names)
cat liste_tables.out | while read table
do
ecd util -U<emuser> -P<empassword> -defexport -table ${table} -dcname "datacenter name" -file yourdirectory.out
done
regards
philmalmaison
do a list of tables in EM SERVER like:
isql -U <emuser> -P <empassword> <<EOF> liste_tables.out
select SCHED_TABLE from DEF_TABLES
where
DATA_CENTER = "datacenter name"
go
EOF
and after removing headers and count row (just living tables names)
cat liste_tables.out | while read table
do
ecd util -U<emuser> -P<empassword> -defexport -table ${table} -dcname "datacenter name" -file yourdirectory.out
done
regards
philmalmaison