Refresh Stock Job Using Enterprise Manager

This topic describes how to run PANTHEON's Refresh Stock function using SQL Server jobs.

In Enterprise Manager, find and expand the desired SQL Server, go to Management → SQL Server Agent, right-click Jobs, and select New Job.

Enter the job Name, but do not change the Category. The Description is optional. Click the Steps tab.

Here you define the steps that should be executed. Click New to add a new step.

Refresh Serial Numbers

Step name: The name of the step. As this one will refresh serial numbers, name it Refresh serial numbers.
Type: Use TSQL, the default.
Database: Select the database on which you want to run the job. This example uses NovoPodjetje.
Command: Enter SQL commands that should be executed, in this case two stored procedures.

exec pPA_SerialNoItemRecalc '', null, null
exec pPA_SerialNoStatusRecalc ''

Click OK to save the step.

Warning Learn more about stored procedures in PANTHEON's database at Datalab's Developer Site under Database Info | DB Info P55 | Procedures, Views, Triggers.

Refresh Prices

Again, click New to add another step.

Step name: The name of the step. This one will Refresh prices.
Type: Use TSQL, the default.
Database: Select the database on which you want to run the job. This example uses NovoPodjetje.
Command: Enter SQL commands that should be executed, in this case three stored procedures.

if object_id('tempdb..#lHE_InventoryIdent') is null
CREATE TABLE [dbo].[#lHE_InventoryIdent]
([acIdent] char(16) COLLATE DATABASE_DEFAULT NOT NULL DEFAULT (''),
    [adDate] datetime NOT NULL DEFAULT (dateadd(day,datediff(day,(0),getdate()),(0))),
    [acWarehouse] char(30) COLLATE DATABASE_DEFAULT NOT NULL DEFAULT (''),
    PRIMARY KEY CLUSTERED (acIdent, adDate, acWarehouse))
else
TRUNCATE TABLE [#lHE_InventoryIdent]

exec pPA_PriceCalc '', null, null, ''
exec pPA_PriceCalcOwnPrice '', null, null, ''
exec pPA_MoveAssmblyRecalc ''

Click OK to save the step.

Refresh Stock

Again click New to add another step.

Step name: The name of the step. This one will Refresh stock.
Type: Use TSQL, the default.
Database: Select the database on which you want to run the job. This example uses NovoPodjetje.
Command: Enter SQL commands that should be executed, in this case a stored procedure.

exec pPA_StockRecalc ''

Click OK to save the step.

Document Header Recalculation

Again, click New to create another step. Here enter:

Step name: The name of the step. This one will Refresh document headers.
Type: Use TSQL, the default.
Database: Select the database on which you want to run the job. This example uses NovoPodjetje.
Command: Enter SQL commands that should be executed, in this case a number of stored procedures.

exec pPA_CashRegRecalc null, null
exec pPA_GLRecalc null, null
exec pPA_OrderHeadRecalc null, null
exec pPA_OrderDispDocRecalc '', null, null
exec pPA_MoveHeadRecalc null, null, 'F'

Click OK to save the step.

Now all the necessary steps are set up. This effectively performs the same function as the Refresh Stock feature in PANTHEON.

Setting a Schedule

Now you need to set up a schedule for the job so it does not have to be run manually. Go to the Schedules tab and click New Schedule.

Type in a name for the job schedule and set the Schedule Type to Recurring. Click Change. to set the recurrence parameters.

Select that the job occurs Daily and Every 1 Day. Under Daily frequency, select Occurs once at: and set the desired time (running during the night is recommended). Click OK several times to close all dialog windows. The new job is now listed in the Jobs panel.

Warning You can schedule a job to run every couple of hours by setting Daily frequency to Occurs every: and specifying the time interval. Note that running the job during business hours may slow down normal work due to increased server load.