How to Check the Status of a Commerce Server Direct Mail Campaign (273953)


The information in this article applies to:

  • Microsoft Commerce Server 2002
  • Microsoft Commerce Server 2000
  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0 Service Pack 2
This article was previously published under Q273953

SUMMARY

This article describe how to obtain the status of a Direct Mail campaign by using the SQL Server Enterprise Manager Microsoft Management Console (MMC). You can use the Commerce Server Campaign module in BizDesk and the DmlRun command prompt utility to view information about a Direct Mail campaign. However, neither of these provides status information. You can use the Graphical User Interface (GUI) in the SQL Server Enterprise Manager MMC to view Direct Mail campaign status information.

MORE INFORMATION

In BizDesk, you can create a Direct Mail campaign, schedule the campaign, test the campaign, and delete the campaign. You can also use the DmlRun command prompt utility to obtain information concerning a Direct Mail campaign. (For more information about DmlRun command, see the Commerce Server documentation.) However, neither method provides an indication of your Direct Mail campaign's status.

By performing the following step-by-step GUI procedure, you can verify the status of a Direct Mail campaign, execute the campaign immediately, apply a non-hourly start time, determine cause of failure, and reschedule a completed Direct Mail campaign:
  1. Open SQL Server Enterprise Manager.
  2. Expand SQL Server Group, expand Your Server Name, expand Management, expand SQL Server Agent, and then expand Jobs.
  3. The CS_DM_SiteName+Num job represents a created Direct Mail campaign for your site. Double-click the task that you want to change.
  4. On the Steps tab, you can view and change the steps that will be performed.
  5. On the Schedules tab, you can do the following:
    • Change the execution time of the job to a non-hourly time (for example, 9:15 AM).
    • Change the occurrence of the task (for example, reoccurring).
    • Turn on the task, and then turn off the task.
    • Create another execution of the job.
  6. On the Notifications tab, if the SQL Server Agent has been configured correctly, you can set up e-mail or pager notifications when the task has completed.
  7. In the Properties dialog box, click Apply to save any changes.
  8. To execute the job immediately, right-click the task, and then click Start Job.
Modification Type:MinorLast Reviewed:7/13/2004
Keywords:kbhowto KB273953
©2004 Microsoft Corporation. All rights reserved.