Step 1: Open the SQL Management Studio, connect
to the SQL server instance and expand the 'SQL Server Agent'.
Step 2: Right-click on the jobs folder and
select 'New job'.
Creating a New SQL Job
Step 3: Enter an appropriate name for the SQL
job on the general tab and choose an owner who has rights to access
the Sana Commerce SQL database.
Step 4: Open the 'Steps' tab and click 'New' at
the bottom of the window to create a new step.
Step 5: Enter 'Cleanup baskets' as the
name of the step and select the 'Transact-SQL script'
type. Then select the Sana Commerce SQL database and enter the
'EXEC dbo.CleanupBaskets' command.
Step 6: Click 'OK' to save the job step.
Creating a Job Step
Step 7: Open the 'Schedules' tab and click
'New' at the bottom of the window.
Step 8: Enter the 'Clean up baskets' name,
select the 'Recurring' schedule type and specify the frequency
of performing the job.
Setting Job Schedule
Step 9: Click 'OK' to save the job
Step 10: Click 'OK' in the 'Job' properties
window to save the entire job.