Forum

Welcome Guest! To enable all features please try to register or login.
Sima
#1 Posted: : 31 October 2012 13:50:13(UTC)
sima

Rank: Member

You have been a member since:: 01/02/2011(UTC)
Posts: 10

Pozdrav,
kako pokrenuti preračun prometa iz Task Scheduler-a?
U stvari potrebno mi je obnavljanje zaliha bez ulaska u Pantheon.

unapred hvala
Sima
IVANK
#2 Posted: : 31 October 2012 14:50:18(UTC)
ivank

Rank: DL Partner

You have been a member since:: 24/04/2009(UTC)
Posts: 3
Man

Možeš da napraviš job iz SQL Server Agent-a ako je Pantheon baza na nekoj verziji SQL Servera koja nije Express.
Druga mogućnost je da napraviš skriptu i da je pokreneš preko Task Schedulera i nekog od alata koji dolaze uz SQL Server kao npr. osql http://msdn.microsoft.com/en-us/library/aa214012(v=sql.80).aspx


Za šta god da se odlučiš treba pozvati sledeće procedure.

-- Obnavljanje zaliha
execute [dbo].[pPA_StockRecalc] '', ''

-- Obnavljanje rezervacija
execute [dbo].[pPA_StockRecalcRes] '', ''

-- Obnavljanje statusa serijskih brojeva
exec pPA_SerialNoStatusRecalc '', ''

-- Obnavljanje cena za vrednovanje
declare @Datum smalldatetime
select @Datum=matzacstanje from param

exec pPA_PriceCalc '', @Datum, null, ''
exec pPA_PriceCalcOwnPrice '', @Datum, null, ''
Sima
#3 Posted: : 01 November 2012 09:46:31(UTC)
sima

Rank: Member

You have been a member since:: 01/02/2011(UTC)
Posts: 10

Hvala Ivane,

rešio kreiranjem: obnovi.bat

sqlcmd -S (local) -d ime_baze -i d:\obnovi.sql -o d:\rezultat.txt -e

a u obnovi.sql upisao poziv procedure koje si naveo

i bat stavio u task
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,510 seconds.