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
![Smile :)](./images/smilies/icon_smile.gif)
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.
That's not totally true.RoHoe wrote:These are 'SELECT' statements, so there's no problem.
Robbie.