Refresh Stock Job Using Enterprise Manager
Refresh Stock Job Using Enterprise Manager
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 don't change the Category. The Description is optional. Click the Steps tab.
Here you define steps that should be exsecuted. Click New to add a new step.
Step 1 - 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.
 |
Learn more about stored procedures in PANTHEON's database at Datalab's Developer Site under Database Info |DB Info P55 | Procedures, Views, Triggers. |
Step 2 - 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.
Step 3 - 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.
4. korak preračuna - Preračunaj glave dokumentov
Ponovno kliknemo New za kreiranje novega koraka. Tu vpišemo:
| 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 basically does the same as the Refresh Stock function in PANTHEON.
Setting a Schedule
Now you just have to set up a schedule for the job so you don't need to run it 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 recurrence parameters.
Select that the jobs occurs Daily and Every 1 Day. Under Daily frequency, select Occurs once at: and set the desired time (during the night is recommended). Click OK several times to close all dialog windows. The new job is now listed in the Jobs panel.
 |
You can schedule a job to run every couple of hours by settings Daily frequency to Occurs every: and specifying the time interval.
Note that running job during business hours may slow down normal work because of the increased server load. |
