peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [quote name='Silence..Please' timestamp='1358365839' post='1303118588'] [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 [/quote] adi sare gani, dba_scheduler_jobs lo kuda historical data untundi kada.. paina babu ki andulo em info ratledu antadu endi??? asal ee OEM ee oka tikkalodi OEM, eppdu tinnaga pani sesi savadu.. sagam time agent unreachable or status unknown ane untadi...
Gachibowli_Diwakar Posted January 16, 2013 Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358365952' post='1303118603'] adi sare gani, dba_scheduler_jobs lo kuda historical data untundi kada.. paina babu ki andulo em info ratledu antadu endi??? asal ee OEM ee oka tikkalodi OEM, eppdu tinnaga pani sesi savadu.. sagam time agent unreachable or status unknown ane untadi... [/quote] nenu asalu ippati dhaka dba_scheduler_jobs lo ye jobs ni schedule cheyaledu [img]https://lh3.googleusercontent.com/-yIM-4OqKEeo/Tffqn8e8AyI/AAAAAAAACyY/HYcbydIdjn0/s200/firestar-1.gif[/img] .. anni crontab lo shell scripts use chesi schedule cheyatam ye .. inka OEM aithe .. adhoka landasura monitoring .. agent varaku bagane untundi .. grid tho issue osthe i cant handle it
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [quote name='Silence..Please' timestamp='1358366087' post='1303118630'] nenu asalu ippati dhaka dba_scheduler_jobs lo ye jobs ni schedule cheyaledu [img]https://lh3.googleusercontent.com/-yIM-4OqKEeo/Tffqn8e8AyI/AAAAAAAACyY/HYcbydIdjn0/s200/firestar-1.gif[/img] .. anni crontab lo shell scripts use chesi schedule cheyatam ye .. inka [b]OEM aithe .. adhoka landasura monitoring [/b].. agent varaku bagane untundi .. grid tho issue osthe i cant handle it [/quote] bokkalodi... ippudu kothaga maku 12C cloud etta mantunaru... adi ela untado chudali.... nen dba_scheduler_jobs lo aite FGA/ Auditing schedules avi chestunta.. daniki ide veasy ga
Gachibowli_Diwakar Posted January 16, 2013 Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358366199' post='1303118646'] bokkalodi... ippudu kothaga maku 12C cloud etta mantunaru... adi ela untado chudali.... nen dba_scheduler_jobs lo aite FGA/ Auditing schedules avi chestunta.. daniki ide veasy ga [/quote] emo .. nenu asalu use cheyaledu ippati dhaka .. anni through scripts ye .. shell scripts works like a charm pakodi scheduler enduku
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [quote name='Silence..Please' timestamp='1358366308' post='1303118668'] emo .. nenu asalu use cheyaledu ippati dhaka .. anni through scripts ye .. shell scripts works like a charm pakodi scheduler enduku [/quote] emo va.. naku a shell nerpincha vachu ga
Gachibowli_Diwakar Posted January 16, 2013 Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358366491' post='1303118699'] emo va.. naku a shell nerpincha vachu ga [/quote] db monitoring scripts untaay ga.. ledha backups schedule chestharu kadha using scripts.. avi chuusi nerchukovatam ye.. thats how I learnt
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [quote name='Silence..Please' timestamp='1358366708' post='1303118725'] db monitoring scripts untaay ga.. ledha backups schedule chestharu kadha using scripts.. avi chuusi nerchukovatam ye.. thats how I learnt [/quote] haha... ade chesi I can read what they do now.. kaani script rayali ante kastam ya...
Gachibowli_Diwakar Posted January 16, 2013 Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358367434' post='1303118819'] haha... ade chesi I can read what they do now.. kaani script rayali ante kastam ya... [/quote] opportunity oche dhaka creativity bayata pettam.. adhi mana natural tendency ga.. nenu kuda right from the scratch raayi ante raayalenu .. anni scripts ni mix-n-match chesi will come up ..
KOTC Posted January 16, 2013 Author 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] ikkada vere jobs vastunai bhayya,OEM 10g lo jobs assign chestam kadha andulo oka job kuda raledhu MGMT_CONFIG_JOB_1 a name tho vastunaii
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358366199' post='1303118646'] bokkalodi... ippudu kothaga maku 12C cloud etta mantunaru... adi ela untado chudali.... nen dba_scheduler_jobs lo aite FGA/ Auditing schedules avi chestunta.. daniki ide veasy ga [/quote] 12c nenu already install chesa bhayya kani windows server meda
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 [quote name='KOTC' timestamp='1358370400' post='1303119270'] ikkada vere jobs vastunai bhayya,OEM 10g lo jobs assign chestam kadha andulo oka job kuda raledhu MGMT_CONFIG_JOB_1 a name tho vastunaii [/quote] hussu.... asal etta sesina ravatledu endi bhayya neeku asala..... denemma... oracle lo SR raise cheyi iga... em kaadu... ade septadu
KOTC Posted January 16, 2013 Author Report Posted January 16, 2013 [quote name='CBZ' timestamp='1358372123' post='1303119482'] hussu.... asal etta sesina ravatledu endi bhayya neeku asala..... denemma... oracle lo SR raise cheyi iga... em kaadu... ade septadu [/quote] Ade chedam anukunta kani e link http://www.dba-oracle.com/t_dbms_job_scheduler.htm aithe undi a dbs_job_scheduler untai ani kani ala unta ani na doubt?? na question neku aithe ardham ayindi kadha bhayya.10g OEM lo ma vallu rman scripts use chesi daniki oka name echaru.So adi skip ayindi asalu em ayindi teliytam ledhu.Nuv chepaninatu a [color=#333333][font=helvetica, arial, sans-serif]dba_scheduler_job_run_details lo untaii leka andulo only jobs which are assigned there scripts on the server untaya ??[/font][/color] [color=#333333][font=helvetica, arial, sans-serif]ikkada confusion enti ante [/font][/color][color=#333333][font=helvetica, arial, sans-serif]dba_scheduler_job_run_details [/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]DBMS_JOB[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]DBMS_SCHEDULER[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]DBMS_AUTO_TASK_ADMIN[/size][/font][/color] [color=#000000][font=tahoma, verdana, sans-serif][size=2]e source chudu mana bhayya echadu same pblm anuko[/size][/font][/color] https://forums.oracle.com/forums/thread.jspa?threadID=2167979&tstart=23
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 asal endulo etikina rakapotam endo naku aite ardam aitale bhayya...
peru_edaite_enti Posted January 16, 2013 Report Posted January 16, 2013 calling acp.. raa vaa. munda mopi teddullo dance aapi eedaki ra...
Recommended Posts