Technological recipes that I've held to prepare some solutions DBA environment. (by Felipe Donoso Bastias)

15 Nov 2007

Oracle: Visualizando los jobs que se están ejecutando:

Para visualizar los jobs que se encuentran coriendo podemos ejecutar lo siguiente:

set linesize 250
col sid for 9999 head 'Session|ID'
col log_user for a10
col job for 9999999 head 'Job'
col broken for a1 head 'B'
col failures for 99 head "fail"
col last_date for a18 head 'Last|Date'
col this_date for a18 head 'This|Date'
col next_date for a18 head 'Next|Date'
col interval for 9999.000 head 'Run|Interval'
col what for a60
select j.sid,
j.log_user,
j.job,
j.broken,
j.failures,
j.last_date||':'||j.last_sec last_date,
j.this_date||':'||j.this_sec this_date,
j.next_date||':'||j.next_sec next_date,
j.next_date - j.last_date interval,
j.what
from (select djr.SID,
dj.LOG_USER, dj.JOB, dj.BROKEN, dj.FAILURES,
dj.LAST_DATE, dj.LAST_SEC, dj.THIS_DATE, dj.THIS_SEC,
dj.NEXT_DATE, dj.NEXT_SEC, dj.INTERVAL, dj.WHAT
from dba_jobs dj, dba_jobs_running djr
where dj.job = djr.job ) j;
Share:

5 Comments:

Anonymous said...

Muy útil, gracias!

thành nguyễn said...

tiếng anh giao tiếp cho trẻ em
chung cư newskyline
chung cư hateco hoàng mai
chung cư hà nội
dịch vụ hoàn thuế gtgt
dịch vụ kế toán thuế trọn gói

dịch vụ quyết toán thuế
khoá học kế toán thuế
trung tâm kế toán
dịch vụ báo cáo thuế
dịch vụ báo cáo tài chính tại tphcm

dich vu ke toan noi bo
dịch vụ dọn dẹp sổ sách trọn gói

xumeiqing said...

true religion
michael kors handbags
cheap jordan shoes
cheap nike air max
jordan shoes
lacoste shoes
wholesale nike shoes
michael kors canada
skechers outlet
coach outlet online
louis vuitton outlet online
chi flat iron
ray ban sunglasses sale
asics gel kayano
michael kors outlet canada
coach factory outlet
nike cortez white
discount nike air max
christian louboutin shoes
nike tn pas cher
ralph lauren pas cher
louis vuitton pas cher
sac longchamp
michael kors outlet store
coach outlet online
supra outlet
designer handbags wholesale
valentino bags
converse outlet
air max 90
versace sunglasses
christian louboutin outlet
michael kors outlet
nike huarache
fake oakleys
louis vuitton handbags
nike huarache black
ferragamo outlet
true religion jeans
rolex daytona
chenzhen20160511

dada24 Xu said...

louis vuitton purse
oakley sunglasses wholesale
louis vuitton factory outlet
rolex watches
michael kors outlet clearance
ugg boots
outlet louis vuitton
christian louboutin outlet
celine handbags
cheap jordan shoes
zhi20161219

caiyan said...

mulberry bags
fred perry
adidas shoes
nike outlet
nike air max
kate spade outlet
birkenstock sandals
fitflops
toms shoes outlet
christian louboutin shoes
0424shizhong

Copyright © DBA TIPS | Powered by Blogger
Design by SimpleWpThemes | Blogger Theme by NewBloggerThemes.com | Free Blogger Templates