Direct Mailer Databases

Direct Mailer uses SQL Server 2000 and SQL Server Agent extensively. The Direct Mailer database is created automatically in SQL Server when you install Commerce Server. You use SQL Server Agent, which runs continually, to schedule and run recurring jobs and to view details about your Direct Mailer jobs. You can check status, the date and time the Direct Mailer jobs were last run, and the next scheduled run time.

Direct Mailer uses the following databases when it is run as an integrated component of Commerce Server:

• DirectMailer database. Contains the details and information associated with the Direct Mailer job. Direct Mailer uses this database to manage mailing lists, maintain job history, and schedule recurring Direct Mailer jobs.
• Campaigns database. Contains the details and information associated with the direct mail campaign item.

The following figure shows Direct Mailer jobs and their details listed in SQL Server Agent.

To start a Direct Mailer job in SQL Server Agent

1. Click Start, point to Programs, point to Microsoft SQL Server 2000, and then click Enterprise Manager.
2. Expand the nodes to the following path: \Microsoft SQL Servers\SQL Server Group\<SQL Server Name>\Management\SQL Server Agent.
3. Click Jobs. The Direct Mailer jobs appear in the right pane of the SQL Server Enterprise Manager.
4. Right click the Direct Mailer job and select Start Job.

Note

• To reschedule a Direct Mailer job, you use the Campaigns Manager module in Commerce Server Business Desk. For information about scheduling a Direct Mailer job, see Scheduling Direct Mail.

See Also

Scheduling Direct Mail

Copyright © 2005 Microsoft Corporation.
All rights reserved.