Creating an SQL job that truncates RequisitePro temp tables

Resolving The Problem

Follow these steps to create an SQL job that truncates the temp tables:

1. Open Microsoft® SQL Server Enterprise Manager by selecting Start > Programs > Microsoft SQL Server > Enterprise Manager.
2. Expand SQL Server Group.
3. Expand the folder called Management.
4. Make sure the SQL Server Agent is running. If the agent is not running right click on it and choose Start. The agent must be running for the job to execute.
5. Right click on the SQL Server Agent and choose New > Job
6. On the General tab, give your new job a recognizable name like "ReqPro Truncate Temp Tables".
7. Choose the Steps tab and click on New.
8. Give the step a name like "truncate'.
9. Make sure the type selected is Transact-SQL Script (TSQL)
10. In the Database list item, make sure your RequisitePro database is selected.
11. Type the following SQL statements into the command window:
• TRUNCATE TABLE REQPRO.RQTRACETABLETEMP
• TRUNCATE TABLE REQPRO.RQGENERICTABLETEMP
• TRUNCATE TABLE REQPRO.RQHIERARCHYTABLETEMP
• TRUNCATE TABLE REQPRO.RQHIERARCHYORDEREDLEVELSTEMP
• TRUNCATE TABLE REQPRO.RQHIERARCHYFINALORDERTEMP
12. Click OK to close that window - you are now back to the Job Properties window.
13. Click on the Schedules tab. This allows you to schedule your job to run. Make sure this job is run only when there is no one using the database.
14. Select New Schedule and choose an appropriate time to schedule this job.
15. Click OK, then click OK again to exit out of the Job Properties window.