Hi,

Whenever I am going to run the folowing batch I get the error 'First error: unexpected token: '{''. The batch is :

global class ZmDmAttachmentCleanupBatch implements Database.Batchable<SObject>, Database.Stateful{

private List<Id> ZmDmAttachmentIds;

private String MarketCleanupId;

public ZmDmAttachmentCleanupBatch() {
        //do nothing   
    }

   
public ZmDmAttachmentCleanupBatch(List<Id> ZmDmAttachmentIds) {
        this.ZmDmAttachmentIds = ZmDmAttachmentIds;
    }
   
public ZmDmAttachmentCleanupBatch(String MarketId) {
        this.MarketCleanupId = MarketId;
    }  

    global Database.QueryLocator start(Database.BatchableContext bc){
        return Database.getQueryLocator(prepareSOQL());
    }

    global void execute(Database.BatchableContext bc, List<Attachment> rows){
            delete rows;
           DataBase.emptyRecycleBin(rows);    
    }
   
    global void finish(Database.BatchableContext bc){
     String CleanupLastRun;
     datetime myDateTime = datetime.now();
     String myDateStr = String.ValueOf(myDateTime);
     Market__c mkt = [select Id,Cleanup_Last_Run__c from market__c
                                                        where Market_Id__c=:MarketCleanupId];

         String CleanupLastRun1 = mkt.Cleanup_Last_Run__c;
         String CleanupLastRun2 = CleanupLastRun1+'Attachment:'+myDateStr;             
        // mkt.Cleanup_Last_Run__c = 'Attachment:'+myDateStr;
              
           update mkt;
          
           Database.executeBatch(new SlAttachmentCleanupBatch('73'),2000);
        System.debug('job finished.');
     
    }
   
    public static void startJob() {
        scheduleJob(2);
    }
   
   
    private String prepareSOQL() {
     
       Market__c mrkt = [select PREV_1_CMPGN_NR__c,X90_Day_Camp_CNT__c from market__c
                                                     where Market_Id__c=:MarketCleanupId];
       List<CDW_Market_Report__c> Parent_id = [select id from CDW_Market_Report__c
                                                      where Market__r.Market_Id__c=:MarketCleanupId];
             system.debug('parent id'+Parent_id);
      
      // List<SObject> results = Database.query(someSOQL);
       Set<Id> resultIds = (new Map<Id,CDW_Market_Report__c>(Parent_id)).keySet();
      // Set<Id> resultIds = new Set<Id> (new Map<Id,CDW_Market_Report__c>(Parent_id).keySet());
      // Set<String> resultIds = (new Map<String,CDW_Market_Report__c>(Parent_id)).keySet();      
       List<Calendar__c> camp = [select CMPGN_NR__c,CMPGN_STRT_DT__c from Calendar__c
                                                    where MRKT_ID__c = :MarketCleanupId order by CMPGN_NR__c desc];

          Integer index = -1;
         
          Integer CampaignIndex=6;

       List<String> Camps=new List<String>();
      
          for(Calendar__c ca: camp){
            Camps.add(String.valueOf(ca.CMPGN_NR__c));
          }

          for(Integer m = 0; m<Camps.size();m++){
             IF(Camps[m].equalsignorecase(mrkt.PREV_1_CMPGN_NR__c)){
             index = m;
             System.debug('index='+ index);
             break;       
             }
          }
       Calendar__c PrevCmpgnStr1=camp[index+CampaignIndex];
              system.debug('final campaign'+ PrevCmpgnStr1);
  
               date startdate= PrevCmpgnStr1.CMPGN_STRT_DT__c;
               Datetime dt = datetime.newInstance(startdate.year(), startdate.month(),startdate.day(),00,00,00);

     // List<Attachment> atc = [select Id from Attachment where ParentId In :resultIds and LastModifiedDate<:dt];
     
     // system.debug('attachmentis'+ atc);

      // String PrevCmpgnStr=Camps[index+CampaignIndex];
      
      String sql = 'SELECT Id FROM Attachment ';
                
           // sql += ' where ParentId In :\''+resultIds+'\' and LastModifiedDate<:\''+dt+'\'';
            sql += ' where ParentId In :'+resultIds+' and LastModifiedDate<:'+dt+'';
           
       system.debug('queryis'+ sql);           
      return sql;
     
    }
   
   
    private Set<String> fetchEligibleMarketCodes() {
        Set<String> marketCodes = new Set<String>();
        for (Market__c market : [Select Market_Id__c from Market__c where Is_ALMPLUS_Enabled__c=true]) {
            marketCodes.add(market.Market_Id__c);
        }
        System.debug('eligible market codes: ' + marketCodes);
        return marketCodes;
    }
   
    private static void scheduleJob(Integer minutesOffset) {
        DateTime currentTime = System.now();
        String scheduleTime = ALMPlusUtils.prepareJobsSchTime(currentTime, minutesOffset); 
        String uniqueJobName = ALMPlusUtils.getUniqueJobName('ZmDmAttachmentCleanupBatch');
        String cronID = System.schedule(uniqueJobName, scheduleTime, new BatchJobScheduler(new ZmDmAttachmentCleanupBatch(), 1000));  //use 10 as the batch size         
    }
   
    //ZmDmAttachmentCleanupBatch zda=new ZmDmAttachmentCleanupBatch('73');
    //zda.startJob();
   
   
}

Can anybody tell me where I am missing in the code.

Regards,
Dip