SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 8056: SQL queries that are written using the Campaign Management Query Window fail when run by the Scheduler

DetailsAboutRate It
If you create a query in the SAS Campaign Management component using
the Query Window instead of the Selection Rule window, and then
schedule that query to run in the Scheduler, the following error
occurs:

   Failed to run selection rule 'xyz'
   Please report the following error (1) Application or Object Defined
     Error
   Scheduled Task Status: FAILED

If you submit this query directly from the SQL Query Window, the query
runs successfully.


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Campaign ManagementMicrosoft Windows 95/987.00
Microsoft Windows NT Workstation7.007.2
Microsoft Windows 2000 Professional7.007.2
Microsoft Windows 2000 Advanced Server7.007.2
Microsoft Windows 2000 Server7.007.2
Microsoft Windows 2000 Datacenter Server7.007.2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.