1- Open SQL Server Enterprise Manager.
2- Expand the trees located in the Console Root pane to the left until the server hosting your site appears.
3- Right-click on the server hosting your site and select “New” > “Job.”
4- Enter a “Name” for the job, e.g. IssueTrak_ApplyAssetAudits.
5- Select “sa” as the “Owner” of the job.
6- Click “Steps” in the tabs displayed at the top of the New Job Properties window.
7- Click “New.”
8- Enter a “Name” for the step, e.g. IssueTrak_ApplyAssetAuditsStep.
9- Select “Transact-SQL Script (TSQL)” as the step “type.”
10- Select your IssueTrak database from the “Database” drop-down menu.
11- Copy and paste or type in the commands:
exec sp_InvItems_ApplyAllExisting
exec sp_InvItems_ApplyAllNew
12- Click “OK.”
13- Click “Schedules” in the tabs displayed at the top of the New Job Properties window.
14- Click “New Schedule.”
15- Enter a “Name” for the schedule, e.g. IssueTrak_ApplyAssetAuditsSchedule.
16- Select “Recurring.”
17- Click “Change” to define the recurrence.
18- Select “Daily” in the “Occurs” section.
19- Select “Occurs every” in the “Daily frequency” section.
20- Select an appropriate interval at which the job should occur, e.g. 15 minutes.
21- Click “OK” until done.