Форум

Welcome Guest! To enable all features please try to register or login.
Osveževanje Kock na SQL-u
Options Go to last post Go to first unread
Previous Topic Next Topic
MARKOTUK
#1 Posted: : 26 April 2011 14:02:22(UTC)
MARKOTUK

Rank: DL Partner

You have been a member since:: 24/04/2009(UTC)
Posts: 51
Vsake toliko časa nam pade osveževanje kock ter predpriprava podatkov na SQL2005. Kakšna ideja?
borpuk
#2 Posted: : 01 May 2011 15:01:05(UTC)
borpuk

Rank: Datalab

You have been a member since:: 24/04/2009(UTC)
Posts: 24
Zdravo,

na kaksen nacin pade, kako izgleda?

LP BP
MARKOTUK
#3 Posted: : 03 May 2011 09:36:08(UTC)
MARKOTUK

Rank: DL Partner

You have been a member since:: 24/04/2009(UTC)
Posts: 51
Vkopljen mamo avtomatsko osvežitev kock ter materialnih view-ov za dashboard. Nekaj časa dela vredu nakar pade brez razloga. Če ga pa,ko me tsranka obvesti, da se podatki niso osvežili, zaženem na roke pa naredi. Razloga, da se osvežitev ne izvede pa ne najdemo. Osvežitev kock imamo narejeno ob 23.00 uri, materialnih view-ov pa ob 03.00. Kakšna ideja?
borpuk
#4 Posted: : 03 May 2011 14:17:05(UTC)
borpuk

Rank: Datalab

You have been a member since:: 24/04/2009(UTC)
Posts: 24
Avtomatsko osveževanje imate verjetno narejeno v scheduled tasks?
Pravite, da zaženete ročno. To pomeni desni klik + Run na scheduled task?
Preverite, ali task dela, če uporabnik, pod katerim je narejen task ni prijavljen v windowse.
Poglejte tudi log izvedbe taskov, morda boste lahko razbrali kaj je problem.
LP BP
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2025, Yet Another Forum.NET
This page was generated in 0,485 seconds.