deals2buy Posted November 13, 2012 Report Posted November 13, 2012 ippudu naaku production lo oka job undi vayya... aa Job lo oka Stored Procedure(SP) undi...Job schedule chesina taruvatha aa SP run avutunndi..ikkadi daka fine next aa SP inturn calls 3-4 other SPs. like SP1 -> SP2 -> SP3 ->SP4 ila anamaata order differ kuda avvochu.... ippudu naa doubt endante... sudden ga ee job run ainappudu error vasthe..ekkada error vachindo chustaam...chusi job restart chestam malli...appudu malla starting nundi run aithada leka ekkadaithe aagipoindo akkada start aithada?? jara cheppandi vayya...
deals2buy Posted November 13, 2012 Author Report Posted November 13, 2012 [quote name='dalapathi' timestamp='1352836795' post='1302790950'] Calling Senior Citizen ACP [/quote] nuvvu deni meeda bhayya?
gali ganna rao Posted November 13, 2012 Report Posted November 13, 2012 naku telisinanta varaku malla starting nunde run avutadi.. but most of the jobs, lo last run to skip kuda chestaru.. for say, if a SP/job executed in sysdate , then skip or ala..
deals2buy Posted November 13, 2012 Author Report Posted November 13, 2012 [quote name='ETHANE_HUNT' timestamp='1352836871' post='1302790969'] naku telisinanta varaku malla starting nunde run avutadi.. but most of the jobs, lo last run to skip kuda chestaru.. for say, if a SP/job executed in sysdate , then skip or ala.. [/quote] ardham kaaledu bhayya but usually SSIS/DTS packages run chesinappudu ekkadaithe aagipoindo akkada nunde start aithadi malli... SPs lo kuda same concept pani chestada leda annadi naa doubt
dalapathi Posted November 13, 2012 Report Posted November 13, 2012 [quote name='deals2buy' timestamp='1352836852' post='1302790963'] nuvvu deni meeda bhayya? [/quote] Nenu Datastage ETL tool
Bairagi From Bapatla Posted November 13, 2012 Report Posted November 13, 2012 [quote name='deals2buy' timestamp='1352836964' post='1302790989'] ardham kaaledu bhayya but usually SSIS/DTS packages run chesinappudu ekkadaithe aagipoindo akkada nunde start aithadi malli... SPs lo kuda same concept pani chestada leda annadi naa doubt [/quote] Job ga run run chesthe edhi ayina 1st nunchi strt ayyidi... ekkada fail ayithe akkadnunchi run cheyali anukunte seperate job create cheyali with steps or manual ga run pettali naku telisinanthavaruku.....
vokatonumberkurrodu Posted November 13, 2012 Report Posted November 13, 2012 re-start ante stored procedure first nunchi start avutundhi... inner stored procedures fail ayithey it depends upon how the stored procedures are called.... suppose inner sp1 fails but it is coded to allow all others to run then all others will run else exception petti fail chestaru.... but generally speaking if you restart a stored proc it will run from the start... DBA ni kadu but DB knowledge tho cheptunna....hope my knowledge is right...
deals2buy Posted November 13, 2012 Author Report Posted November 13, 2012 [quote name='dalapathi' timestamp='1352837187' post='1302791031'] Nenu Datastage ETL tool [/quote] oh ok..mee dantlo Jobs concept undada mari? [quote name='Bairagi From Bapatla' timestamp='1352837418' post='1302791084'] Job ga run run chesthe edhi ayina 1st nunchi strt ayyidi... [b][color=#ff0000]ekkada fail ayithe akkadnunchi run cheyali anukunte seperate job create cheyali with steps or manual ga run pettali naku telisinanthavaruku.....[/color][/b] [/quote]may be u r right... individual steps ga create cheste akkada nundi start avutundi anukunta.. [quote name='vokatonumberkurrodu' timestamp='1352837455' post='1302791093'] re-start ante stored procedure first nunchi start avutundhi... inner stored procedures fail ayithey it depends upon how the stored procedures are called.... suppose inner sp1 fails but it is coded to allow all others to run then all others will run else exception petti fail chestaru.... but generally speaking if you restart a stored proc it will run from the start... DBA ni kadu but DB knowledge tho cheptunna....hope my knowledge is right... [/quote] oh ok.. ya 1st SP fail aithe complete ga bayatiki vachetattu chesta...ee concept telusu bhayya ok first nundi start aithadani teleedu..anduke adigaanu ikkada..
dalapathi Posted November 13, 2012 Report Posted November 13, 2012 [quote name='deals2buy' timestamp='1352837708' post='1302791137'] oh ok..mee dantlo Jobs concept undada mari? may be u r right... individual steps ga create cheste akkada nundi start avutundi anukunta.. oh ok.. ya 1st SP fail aithe complete ga bayatiki vachetattu chesta...ee concept telusu bhayya ok first nundi start aithadani teleedu..anduke adigaanu ikkada.. [/quote] Maaku datastage loney restart point ani vuntayai ... so, job ekkada fail ayyindhoo ... i mean SP3 ooh SP4 ooh fail ayitey mallie first nudni run cheyyavalsina avasarma ledu ... akkadi nudni chestey chaalu
deals2buy Posted November 13, 2012 Author Report Posted November 13, 2012 [quote name='dalapathi' timestamp='1352838290' post='1302791200'] Maaku datastage loney restart point ani vuntayai ... so, job ekkada fail ayyindhoo ... i mean SP3 ooh SP4 ooh fail ayitey mallie first nudni run cheyyavalsina avasarma ledu ... akkadi nudni chestey chaalu [/quote] cool...mari maa dantlo Microsoft vaadu inka enduku pettaledu? [img]http://www.manadb.com/Smileys/default/dizzy-smiley-emoticon.gif[/img]
Power Star Posted November 13, 2012 Report Posted November 13, 2012 [img]http://www.gifsforum.com/images/gif/sexy/grand/Diora-Baird-Posing.gif[/img]
deals2buy Posted November 13, 2012 Author Report Posted November 13, 2012 [quote name='BOY' timestamp='1352843147' post='1302791678'] [img]http://www.gifsforum.com/images/gif/sexy/grand/Diora-Baird-Posing.gif[/img] [/quote] neeku inka images post cheyyadam raaledendi vayya? [color=#282828][font=helvetica, arial, sans-serif][img]http://www.manadb.com/Smileys/default/Brahmi.gif[/img][/font][/color]
gundugadu Posted November 13, 2012 Report Posted November 13, 2012 SQL job lo check points or save points yem vundavu bayya. nuvvu restart chesthe the job will start from modali nunchi
Recommended Posts