DB2 equivalent to SQL Server's SYSJOBS -


i db2 novice , need or pointers in right direction. need capture following fields (or similar) in db2, can capture in sql server following sql code,

select         jobs.name        ,jstep.step_name        ,jstep.command sysjobs jobs  inner join sysjobsteps jstep on jstep.job_id = jobs.job_id jobs.name = 'some_job_name' 

surely, there's similar db2. but, can't seem find or google right combinations of key words. appreciated.

db2 uses administrative task scheduler (ats). view need systools.admin_task_list. on side note, status of each task in systools.admin_task_status.

hth.


Comments

Popular posts from this blog

python - argument must be rect style object - Pygame -

c++ - Qt setGeometry: Unable to set geometry -

php - Zend Framework / Skeleton-Application / Composer install issue -