Schedule the Import Process

Once you've configured the data source and successfully imported data, schedule the import process via the Task Scheduler, a System Tools accessory that ships with Windows.

The following overview describes how to create a task in the Scheduler and the arguments to use when scheduling the import process.

To create a task in the Scheduler:

1. Under Task Scheduler Library, select Cherwell Asset Management.
2. In the Actions pane, under Cherwell Asset Management, select Create Task...
3. Select the Actions tab, then select New....
4. In the New Action dialog box, select Start a Program and type in the path for CAM External Connector, or select Browse to find it.
   The CAM External Connector is usually located in C:\Program Files (x86)\Cherwell Asset Management\Connector.
5. In the Add arguments box, type the necessary argument(s):
   • For hosted installations:

     /C <data source name>

   • For on-premises installations:

     /S <SQL server> /d <CAM database> /U <login id> /P
           <password> /C <data source name>

6. Select OK.
7. In the Create Task dialog box, select the Triggers tab to define how often to run the task.
8. Select OK.
9. Select the General tab, and type a name for the task.
10. Check the Run with highest privileges check box.
11. Select OK.

Notes:

• For on-premises installations only: The /S value must include the database instance if one exists (example: /S mysqlserver\instance). This should be the SQL Server that is hosting the CAM database, not the SCCM server and database.
• If the data source name includes spaces, you must enclose it in quotation marks (example: /C "my data source").