1- Open SQL Server Management Studio.
2- Right-click on the “SQL Server Agent” located in the Object Explorer pane to the left and select “New Job.”
3- Enter a “Name” for the job, e.g. IssueTrak_ApplyAssetAudits.
4- Select “sa” as the “Owner” of the job.
5- Click “Steps” in the pages displayed in the left pane of the New Job window.
6- Click “New.”
7- Enter a “Name” for the step, e.g. IssueTrak_ApplyAssetAuditsStep.
8- Select “Transact-SQL Script (TSQL)” as the step “type.”
9- Select your IssueTrak database from the “Database” drop-down menu.
10- Copy and paste or type in the commands:
exec sp_InvItems_ApplyAllExisting
exec sp_InvItems_ApplyAllNew
11- Click “OK.”
12- Click “Schedules” in the pages displayed in the left pane of the New Job window.
13- Click “New.”
14- Enter a “Name” for the schedule, e.g. IssueTrak_ApplyAssetAuditsSchedule.
15- Select “Recurring” as the “Schedule type.”
16- Select “Daily” as the “Frequency.”
17- Select “Occurs Every” in the “Daily frequency” section.
18- Select an appropriate interval at which the job should occur, e.g. 15 minutes.
19- Click “OK” until done.
NOTE: Note there are two commands. The first applies audit records to asset items that already exist. The second processes the audit records where there is not already an asset item record and creates them.