Extracting the job schedule
Extracting the job schedule
hi,
i am new here.
anybody can help to provide me with the sql on how to extract the list of jobs that is in the db?
Thanks
i am new here.
anybody can help to provide me with the sql on how to extract the list of jobs that is in the db?
Thanks
Hi, you can use :
select distinct
substr (application,1,4) OScycle,
' ', substr (application,5,20) Description_cycle,
' ', (job_name) Jobname,
' ', substr (description,1,40) description_job
from
ecs.def_job
ORDER by
1;
With this query you can also request for example the DAYS_CAL or WEEKS_CAL, DAY_STR or W_DAY_STR from the database.
select distinct
substr (application,1,4) OScycle,
' ', substr (application,5,20) Description_cycle,
' ', (job_name) Jobname,
' ', substr (description,1,40) description_job
from
ecs.def_job
ORDER by
1;
With this query you can also request for example the DAYS_CAL or WEEKS_CAL, DAY_STR or W_DAY_STR from the database.
hello,RoHoe wrote:Hi, you can use :
select distinct
substr (application,1,4) OScycle,
' ', substr (application,5,20) Description_cycle,
' ', (job_name) Jobname,
' ', substr (description,1,40) description_job
from
ecs.def_job
ORDER by
1;
With this query you can also request for example the DAYS_CAL or WEEKS_CAL, DAY_STR or W_DAY_STR from the database.
how do you execute this script? must i connect to the EM server before?
thanks
That's not totally true.RoHoe wrote:These are 'SELECT' statements, so there's no problem.
Robbie.
If you execute a very important SELECT, you can decrease database performance, and even stop database.
It could be a very important issue for all your environnement.
The best way is to duplicate database content and try SELECT on duplicated database.
hello,
database = Oracle
here is my test.bat
cd E:\Program Files\BMC Software\CONTROL-M Server\Ctm_server\Exe\
sql.exe
select DATA_CNTR_NAME from CMS_CMNPRM;
go
and here my result
C:\Documents and Settings\MonUSER>E:\TEMP\extorac.bat
C:\Documents and Settings\MonUSER>cd E:\Program Files\BMC Software\CONTROL-M Serv
er\Ctm_server\Exe\
C:\Documents and Settings\MonUSER>sql.exe
1>
here i tape exit, because the scipt wait for command SQL
C:\Documents and Settings\MonUSER>select DATA_CNTR_NAME from CMS_CMNPRM;
'select' n'est pas reconnu en tant que commande interne
ou externe, un programme exécutable ou un fichier de commandes.
C:\Documents and Settings\MonUSER>go
'go' n'est pas reconnu en tant que commande interne
ou externe, un programme exécutable ou un fichier de commandes.
C:\Documents and Settings\MonUSER>
thanks for help )
database = Oracle
here is my test.bat
cd E:\Program Files\BMC Software\CONTROL-M Server\Ctm_server\Exe\
sql.exe
select DATA_CNTR_NAME from CMS_CMNPRM;
go
and here my result
C:\Documents and Settings\MonUSER>E:\TEMP\extorac.bat
C:\Documents and Settings\MonUSER>cd E:\Program Files\BMC Software\CONTROL-M Serv
er\Ctm_server\Exe\
C:\Documents and Settings\MonUSER>sql.exe
1>
here i tape exit, because the scipt wait for command SQL
C:\Documents and Settings\MonUSER>select DATA_CNTR_NAME from CMS_CMNPRM;
'select' n'est pas reconnu en tant que commande interne
ou externe, un programme exécutable ou un fichier de commandes.
C:\Documents and Settings\MonUSER>go
'go' n'est pas reconnu en tant que commande interne
ou externe, un programme exécutable ou un fichier de commandes.
C:\Documents and Settings\MonUSER>
thanks for help )