KOTC Posted January 16, 2013 Report Posted January 16, 2013 Manam oem lo job schedule chestam kadha adi database save avtundha? avute evaru ayina job delete cheste ela tesulukovali? ippudu Catdb database use chese na OEM run avtundi nenu koni jobs schedule chesa OEM use chesi kani jobs miss avutunai,avi evaru ayina delete chesara leka a schedule ni catdb ni query chesete telusundha zara chepandi vayya
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='vissu' timestamp='1358356565' post='1303117207'] Help [/quote] thanks bhayya help
Joey_Tribbiani Posted January 16, 2013 Report Posted January 16, 2013 Yeah bhayya OEM DB lo save autai .. OEM console lo login avvu jobs lo chustunte kanapadam leda ?
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='Joey_Tribbiani' timestamp='1358357526' post='1303117386'] Yeah bhayya OEM DB lo save autai .. OEM console lo login avvu jobs lo chustunte kanapadam leda ? [/quote] Ledhu ade kadha problem a OEM console kanipiytam ledhu aa job evadu delete chesado asalu em ayinda telsukovali
CheGuevara Posted January 16, 2013 Report Posted January 16, 2013 e view lo vetiki chudu...dba_scheduler_jobs
Joey_Tribbiani Posted January 16, 2013 Report Posted January 16, 2013 https://forums.oracle.com/forums/thread.jspa?threadID=2167979&tstart=23
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [quote name='Joey_Tribbiani' timestamp='1358357526' post='1303117386'] Yeah bhayya[b] OEM DB[/b] lo save autai .. OEM console lo login avvu jobs lo chustunte kanapadam leda ? [/quote] OEM ki DB eda untundi vaa?? OP-- OEM lone configured job status chusava? what did you see? ee OEM vadutunaru meru? maku aite 12C undi...
bokuboy Posted January 16, 2013 Report Posted January 16, 2013 [quote name='CheGuevara' timestamp='1358358150' post='1303117498'] e view lo vetiki chudu...dba_scheduler_jobs [/quote] nee dp pic source cheppava
Joey_Tribbiani Posted January 16, 2013 Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358360122' post='1303117843'] OEM ki DB eda untundi vaa?? OP-- OEM lone configured job status chusava? what did you see? ee OEM vadutunaru meru? maku aite 12C undi... [/quote] WHen i say DB , Repository bhayya , OEM ki daani own database kavali kada .. if not where is stores all target data , alerts , job status etc
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [quote name='Joey_Tribbiani' timestamp='1358360235' post='1303117862'] WHen i say DB , Repository bhayya , OEM ki daani own database kavali kada .. if not where is stores all target data , alerts , job status etc [/quote] ohk repo na.. ok ok...ya ade ga... DB anesariki doubt ochindi..
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='CheGuevara' timestamp='1358358150' post='1303117498'] e view lo vetiki chudu...dba_scheduler_jobs [/quote] andulo em ledhu bhayya kani dbms_job,dbms_scheduler undi kani adi query cheste ORA-04044: procedure, function, package, or type is not allowed here kani a view desc cheste matram SQL> desc dbms_job; FUNCTION BACKGROUND_PROCESS RETURNS BOOLEAN PROCEDURE BROKEN Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- JOB BINARY_INTEGER IN BROKEN BOOLEAN IN NEXT_DATE DATE IN DEFAULT PROCEDURE CHANGE Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- JOB BINARY_INTEGER IN WHAT VARCHAR2 IN NEXT_DATE DATE IN INTERVAL VARCHAR2 IN INSTANCE BINARY_INTEGER IN DEFAULT FORCE BOOLEAN IN DEFAULT PROCEDURE INSTANCE Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- JOB BINARY_INTEGER IN INSTANCE BINARY_INTEGER IN FORCE BOOLEAN IN DEFAULT PROCEDURE INTERVAL Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- JOB BINARY_INTEGER IN INTERVAL VARCHAR2 IN PROCEDURE ISUBMIT Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- JOB BINARY_INTEGER IN WHAT VARCHAR2 IN NEXT_DATE DATE IN INTERVAL VARCHAR2 IN DEFAULT NO_PARSE BOOLEAN IN DEFAULT FUNCTION IS_JOBQ RETURNS BOOLEAN PROCEDURE NEXT_DATE Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- JOB BINARY_INTEGER IN NEXT_DATE DATE IN PROCEDURE REMOVE Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- JOB BINARY_INTEGER IN PROCEDURE RUN Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- JOB BINARY_INTEGER IN FORCE BOOLEAN IN DEFAULT PROCEDURE SUBMIT Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- JOB BINARY_INTEGER OUT WHAT VARCHAR2 IN NEXT_DATE DATE IN DEFAULT INTERVAL VARCHAR2 IN DEFAULT NO_PARSE BOOLEAN IN DEFAULT INSTANCE BINARY_INTEGER IN DEFAULT FORCE BOOLEAN IN DEFAULT PROCEDURE USER_EXPORT Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- JOB BINARY_INTEGER IN MYCALL VARCHAR2 IN/OUT PROCEDURE USER_EXPORT Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- JOB BINARY_INTEGER IN MYCALL VARCHAR2 IN/OUT MYINST VARCHAR2 IN/OUT PROCEDURE WHAT Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- JOB BINARY_INTEGER IN WHAT VARCHAR2 IN em ardham avuthe ento
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='Joey_Tribbiani' timestamp='1358358157' post='1303117500'] [url="https://forums.oracle.com/forums/thread.jspa?threadID=2167979&tstart=23"]https://forums.oracl...67979&tstart=23[/url] [/quote] thanks bhayya kani views lo info ravtam le kinda post chesa o/p
Recommended Posts