KOTC Posted January 16, 2013 Author 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] 10g bhayya ala chudachu kani a jobs disppear ayyai certain date roju enduku ayyai asalu ani teliytam ledhu a jobs lo ki veli chuste skipped,deleted in successed lo em matter ledhu. a view repository lo database ekkada save avtundi?avute ela chudali ani?
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 Feature [i]dbms_job[/i] [i]dbms_scheduler[/i] Provide full integration of job creation and modification in Oracle Enterprise Manager. Yes Yes Provide privileges and roles specifically for the scheduler to increase control over the scheduling of jobs. No Yes http://www.dba-oracle.com/t_dbms_job_scheduler.htm kani ela chudalii a jobs nii
Joey_Tribbiani Posted January 16, 2013 Report Posted January 16, 2013 [font="Courier New"]select job_id,[/font] [font="Courier New"] freq_type,[/font] [font="Courier New"] freq_interval,[/font] [font="Courier New"] freq_subday_type,[/font] [font="Courier New"] freq_subday_interval,[/font] [font="Courier New"] freq_relative_interval,[/font] [font="Courier New"] freq_recurrence_factor,[/font] [font="Courier New"] active_start_date,[/font] [font="Courier New"] active_end_date,[/font] [font="Courier New"] active_start_time, [/font] [font="Courier New"] active_end_time, [/font] [font="Courier New"] schedule_id[/font] [font="Courier New"]from dba_scheduler_jobs;[/font] Have you tried this Bhayya
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='Joey_Tribbiani' timestamp='1358362035' post='1303118058'] [font=Courier New]select job_id,[/font] [font=Courier New] freq_type,[/font] [font=Courier New] freq_interval,[/font] [font=Courier New] freq_subday_type,[/font] [font=Courier New] freq_subday_interval,[/font] [font=Courier New] freq_relative_interval,[/font] [font=Courier New] freq_recurrence_factor,[/font] [font=Courier New] active_start_date,[/font] [font=Courier New] active_end_date,[/font] [font=Courier New] active_start_time, [/font] [font=Courier New] active_end_time, [/font] [font=Courier New] schedule_id[/font] [font=Courier New]from dba_scheduler_jobs;[/font] Have you tried this Bhayya [/quote] yup ORA-00904: "SCHEDULE_ID": invalid identifier
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 SQL> desc dba_scheduler_jobs Name Null? Type ----------------------------------------- -------- ---------------------------- OWNER VARCHAR2(30) JOB_NAME VARCHAR2(30) JOB_SUBNAME VARCHAR2(30) JOB_STYLE VARCHAR2(11) JOB_CREATOR VARCHAR2(30) CLIENT_ID VARCHAR2(64) GLOBAL_UID VARCHAR2(32) PROGRAM_OWNER VARCHAR2(4000) PROGRAM_NAME VARCHAR2(4000) JOB_TYPE VARCHAR2(16) JOB_ACTION VARCHAR2(4000) NUMBER_OF_ARGUMENTS NUMBER SCHEDULE_OWNER VARCHAR2(4000) SCHEDULE_NAME VARCHAR2(4000) SCHEDULE_TYPE VARCHAR2(12) START_DATE TIMESTAMP(6) WITH TIME ZONE REPEAT_INTERVAL VARCHAR2(4000) EVENT_QUEUE_OWNER VARCHAR2(30) EVENT_QUEUE_NAME VARCHAR2(30) EVENT_QUEUE_AGENT VARCHAR2(256) EVENT_CONDITION VARCHAR2(4000) EVENT_RULE VARCHAR2(65) FILE_WATCHER_OWNER VARCHAR2(195) FILE_WATCHER_NAME VARCHAR2(195) END_DATE TIMESTAMP(6) WITH TIME ZONE JOB_CLASS VARCHAR2(30) ENABLED VARCHAR2(5) AUTO_DROP VARCHAR2(5) RESTARTABLE VARCHAR2(5) STATE VARCHAR2(15) JOB_PRIORITY NUMBER RUN_COUNT NUMBER MAX_RUNS NUMBER FAILURE_COUNT NUMBER MAX_FAILURES NUMBER RETRY_COUNT NUMBER LAST_START_DATE TIMESTAMP(6) WITH TIME ZONE LAST_RUN_DURATION INTERVAL DAY(9) TO SECOND(6) NEXT_RUN_DATE TIMESTAMP(6) WITH TIME ZONE SCHEDULE_LIMIT INTERVAL DAY(3) TO SECOND(0) MAX_RUN_DURATION INTERVAL DAY(3) TO SECOND(0) LOGGING_LEVEL VARCHAR2(11) STOP_ON_WINDOW_CLOSE VARCHAR2(5) INSTANCE_STICKINESS VARCHAR2(5) RAISE_EVENTS VARCHAR2(4000) SYSTEM VARCHAR2(5) JOB_WEIGHT NUMBER NLS_ENV VARCHAR2(4000) SOURCE VARCHAR2(128) NUMBER_OF_DESTINATIONS NUMBER DESTINATION_OWNER VARCHAR2(384) DESTINATION VARCHAR2(384) CREDENTIAL_OWNER VARCHAR2(30) CREDENTIAL_NAME VARCHAR2(30) INSTANCE_ID NUMBER DEFERRED_DROP VARCHAR2(5) ALLOW_RUNS_IN_RESTRICTED_MODE VARCHAR2(5) COMMENTS VARCHAR2(240) FLAGS NUMBER Indulo, JOB_NAME, SCHEDULE_TYPE, START_DATE, EVENT_RULE, END_DATE, ENABLED, STATE, RUN_COUNT, FAILURE_COUNT, LAST_START_DATE, LAST_RUN_DURATION, NEXT_RUN_DATE, COMMENTS select chesi chudu
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358362402' post='1303118117'] SQL> desc dba_scheduler_jobs Name Null? Type ----------------------------------------- -------- ---------------------------- OWNER VARCHAR2(30) JOB_NAME VARCHAR2(30) JOB_SUBNAME VARCHAR2(30) JOB_STYLE VARCHAR2(11) JOB_CREATOR VARCHAR2(30) CLIENT_ID VARCHAR2(64) GLOBAL_UID VARCHAR2(32) PROGRAM_OWNER VARCHAR2(4000) PROGRAM_NAME VARCHAR2(4000) JOB_TYPE VARCHAR2(16) JOB_ACTION VARCHAR2(4000) NUMBER_OF_ARGUMENTS NUMBER SCHEDULE_OWNER VARCHAR2(4000) SCHEDULE_NAME VARCHAR2(4000) SCHEDULE_TYPE VARCHAR2(12) START_DATE TIMESTAMP(6) WITH TIME ZONE REPEAT_INTERVAL VARCHAR2(4000) EVENT_QUEUE_OWNER VARCHAR2(30) EVENT_QUEUE_NAME VARCHAR2(30) EVENT_QUEUE_AGENT VARCHAR2(256) EVENT_CONDITION VARCHAR2(4000) EVENT_RULE VARCHAR2(65) FILE_WATCHER_OWNER VARCHAR2(195) FILE_WATCHER_NAME VARCHAR2(195) END_DATE TIMESTAMP(6) WITH TIME ZONE JOB_CLASS VARCHAR2(30) ENABLED VARCHAR2(5) AUTO_DROP VARCHAR2(5) RESTARTABLE VARCHAR2(5) STATE VARCHAR2(15) JOB_PRIORITY NUMBER RUN_COUNT NUMBER MAX_RUNS NUMBER FAILURE_COUNT NUMBER MAX_FAILURES NUMBER RETRY_COUNT NUMBER LAST_START_DATE TIMESTAMP(6) WITH TIME ZONE LAST_RUN_DURATION INTERVAL DAY(9) TO SECOND(6) NEXT_RUN_DATE TIMESTAMP(6) WITH TIME ZONE SCHEDULE_LIMIT INTERVAL DAY(3) TO SECOND(0) MAX_RUN_DURATION INTERVAL DAY(3) TO SECOND(0) LOGGING_LEVEL VARCHAR2(11) STOP_ON_WINDOW_CLOSE VARCHAR2(5) INSTANCE_STICKINESS VARCHAR2(5) RAISE_EVENTS VARCHAR2(4000) SYSTEM VARCHAR2(5) JOB_WEIGHT NUMBER NLS_ENV VARCHAR2(4000) SOURCE VARCHAR2(128) NUMBER_OF_DESTINATIONS NUMBER DESTINATION_OWNER VARCHAR2(384) DESTINATION VARCHAR2(384) CREDENTIAL_OWNER VARCHAR2(30) CREDENTIAL_NAME VARCHAR2(30) INSTANCE_ID NUMBER DEFERRED_DROP VARCHAR2(5) ALLOW_RUNS_IN_RESTRICTED_MODE VARCHAR2(5) COMMENTS VARCHAR2(240) FLAGS NUMBER Indulo, JOB_NAME, SCHEDULE_TYPE, START_DATE, EVENT_RULE, END_DATE, ENABLED, STATE, RUN_COUNT, FAILURE_COUNT, LAST_START_DATE, LAST_RUN_DURATION, NEXT_RUN_DATE, COMMENTS select chesi chudu [/quote] chesa bhayya kinda oka bhayya chepadu kadha a error vastundii
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [quote name='KOTC' timestamp='1358362640' post='1303118150'] chesa bhayya kinda oka bhayya chepadu kadha a error vastundii [/quote] adi kakunda, (andulo scheudler_ID ni tesesi ivvu) or nen ichina fields ni query cheyu.. poni idi try cheyi: select JOB_NAME ||'-'|| SCHEDULE_TYPE ||'-'|| [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]START_DATE ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]EVENT_RULE ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]END_DATE ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]ENABLED ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]STATE ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]RUN_COUNT ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]FAILURE_COUNT ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]LAST_START_DATE ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]LAST_RUN_DURATION ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]NEXT_RUN_DATE ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]COMMENTS from [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]dba_scheduler_jobs where JOB_NAME='&YOUR_JOB_NAME';[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]kasta padi rasa vaa.. try cheyu idi[/background][/size][/font][/color]
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358362943' post='1303118182'] adi kakunda, (andulo scheudler_ID ni tesesi ivvu) or nen ichina fields ni query cheyu.. poni idi try cheyi: select JOB_NAME ||'-'|| SCHEDULE_TYPE ||'-'|| [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]START_DATE ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]EVENT_RULE ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]END_DATE ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]ENABLED ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]STATE ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]RUN_COUNT ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]FAILURE_COUNT ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]LAST_START_DATE ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]LAST_RUN_DURATION ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]NEXT_RUN_DATE ||'-'|| [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]COMMENTS from [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]dba_scheduler_jobs where JOB_NAME='&YOUR_JOB_NAME';[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]kasta padi rasa vaa.. try cheyu idi[/background][/size][/font][/color] [/quote] really appreciate bhayya nuv pyna echindi try chesa same andulo okati error estundi kani same error ORA-00904: "EVENT_RULE": invalid identifier adi tesi cheste vere okati vastundi so asalu pblm ento teliytam ledhu bhayya
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [quote name='KOTC' timestamp='1358363086' post='1303118203'] really appreciate bhayya nuv pyna echindi try chesa same andulo okati error estundi kani same error ORA-00904: "EVENT_RULE": invalid identifier adi tesi cheste vere okati vastundi so asalu pblm ento teliytam ledhu bhayya [/quote] oka pani cheyi, nee db loki login aiyi desc dba_scheduler_jobs kottu.. andulo EVENT_RULE undo ledo chudu, nuvu desc kottaka, nen cheppina columns unnayo ledo chudu, em levo adi tesesi query ivvu
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [color=#333333][font=Georgia,] select log_date[/font][/color][color=#333333][font=Georgia,] , job_name[/font][/color][color=#333333][font=Georgia,] , status[/font][/color][color=#333333][font=Georgia,] , req_start_date[/font][/color][color=#333333][font=Georgia,] , actual_start_date[/font][/color][color=#333333][font=Georgia,] , run_duration[/font][/color][color=#333333][font=Georgia,] from dba_scheduler_job_run_details[/font][/color][color=#333333][font=Georgia,] WHERE JOB_NAME LIKE ‘%your_job_wild_card_entry%’[/font][/color] [color=#333333][font=Georgia,] idi kuda oksari try cheyu vayya[/font][/color]
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358363803' post='1303118327'] [color=#333333][font=Georgia,]select log_date[/font][/color] [color=#333333][font=Georgia,], job_name[/font][/color] [color=#333333][font=Georgia,], status[/font][/color] [color=#333333][font=Georgia,], req_start_date[/font][/color] [color=#333333][font=Georgia,], actual_start_date[/font][/color] [color=#333333][font=Georgia,], run_duration[/font][/color] [color=#333333][font=Georgia,]from dba_scheduler_job_run_details[/font][/color] [color=#333333][font=Georgia,]WHERE JOB_NAME LIKE ‘%your_job_wild_card_entry%’[/font][/color] [color=#333333][font=Georgia,]idi kuda oksari try cheyu vayya[/font][/color] [/quote] Thanks oka kotha point nerchukuna nuv chepinatu chusa a view lo a tesi chesa run ayindi kani no rows ani vastundi a job name este ?
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [quote name='KOTC' timestamp='1358364290' post='1303118400'] Thanks oka kotha point nerchukuna nuv chepinatu chusa a view lo a tesi chesa run ayindi kani no rows ani vastundi a job name este ? [/quote] Ok toad unda neku? can you login to toad, if yes, [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]select log_date[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)], job_name[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)], status[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)], req_start_date[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)], actual_start_date[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)], run_duration[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from dba_scheduler_job_run_details;[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]ani kotti chdu, results vostai, appudu andulo asal em em jobs unnayo chudu.[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]toad enduku ante, formatting manaki readable ga undati, you can export to excel to view at ease also[/background][/size][/font][/color]
Gachibowli_Diwakar Posted January 16, 2013 Report Posted January 16, 2013 [color=#333333][font=Verdana, Tahoma,]SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details;[/font][/color] [color=#333333][font=Verdana, Tahoma,]try that and see .. aah view lo historical information about the jobs that were scheduled and ran untaay[/font][/color]
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [quote name='Silence..Please' timestamp='1358365769' post='1303118577'] [color=#333333]SELECT job_name, log_date, status, actual_start_date, run_duration, cpu_used FROM dba_scheduler_job_run_details;[/color] [color=#333333]try that and see .. aah view lo historical information about the jobs that were scheduled and ran untaay[/color] [/quote] repost.. upar nen already seppesina...
Gachibowli_Diwakar Posted January 16, 2013 Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358365156' post='1303118509'] Ok toad unda neku? can you login to toad, if yes, [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]select log_date[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)], job_name[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)], status[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)], req_start_date[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)], actual_start_date[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)], run_duration[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from dba_scheduler_job_run_details;[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]ani kotti chdu, results vostai, appudu andulo asal em em jobs unnayo chudu.[/background][/size][/font][/color] [color=#333333][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]toad enduku ante, formatting manaki readable ga undati, you can export to excel to view at ease also[/background][/size][/font][/color] [/quote][img]https://lh3.googleusercontent.com/-yIM-4OqKEeo/Tffqn8e8AyI/AAAAAAAACyY/HYcbydIdjn0/s200/firestar-1.gif[/img] repost sql developer kuda bagane untundi .. sql developer use chesthe.. license ki pay cheyyakkarledu ..adhe toad aithe u have to buy
Recommended Posts