Hi ,

Thanks for the reply.

I have written my code in batch and tried to test it. I am getting exception as Too Many SOQL:201

My Code:

/This is the scheduler class 
global class GetEventDetailsScheduler implements Schedulable{ 

//Cron expression to run the scheduler for every hour. 
//Seconds Minutes Hours Day_of_month Month Day_of_week optional_year 
public static String CRON_EXP = '0 0 0-23 ? * SUN-SAT';

 //Default constructor 
 global void GetEventDetailsScheduler(){}

 //Method which invoke the Database.executeBatch() method 
global void startGetEventDetailsScheduler (){ 
String query='select Id,UserName from User where isActive=true';
 GetWebExEventDetailsBatch webExEventDetails= new GetWebExEventDetailsBatch(query); 
 Database.executeBatch(webExEventDetails, 1); 
}
// Method which invoked from VF page to start the Scheduler.
 public static void start(){ 
 System.schedule('Get Event Details', CRON_EXP, new GetEventDetailsScheduler()); 
 }
 // Method from Schedulable interface.
 global void execute(SchedulableContext ctx){ 
 startGetEventDetailsScheduler(); 
 }
}


 /**
 * This is the batch job to get the details of each event of each user. 
 * */
global  class GetWebExEventDetailsBatch implements Database.Batchable<User>,Database.AllowsCallouts, Database.Stateful{
//Variable to store the query string.
private String query;

// Parametrized constructor which takes parameter of of the type String.
global GetWebExEventDetailsBatch(String query){
		this.query =query;
	}
// Method which  returs the all active users from the oragnization.
global Iterable<User> start(Database.batchableContext BC){
		return Database.query(query);
	}
	global void execute(Database.BatchableContext BC, List<User> users){
		for(User orgUser: users){
			if(null!=orgUser){
				// Check permission for each custom object.
				Id userId=orgUser.Id;
				if(checkObjectPermission(userId)){
				  SOQL to get all the active events and created by the orgUser.
				  for each active event{
				    // 1 callout . 
					// process the callout. 
				  }
				}
			}
		}
		// 3 more DMLS
	}
global void finish(Database.BatchableContext BC){	
 /* Schedule 1 more batch for another callout. This batch has same process. */
}

//Check the permission for 3 objects so I have 3 SOQL.
public static boolean checkObjectPermission(Id userId){
ObjectPermissions obj1=[SELECT PermissionsRead,PermissionsEdit,PermissionsDelete,PermissionsCreate
			                  FROM ObjectPermissions  where (ParentId IN (SELECT PermissionSetId FROM PermissionSetAssignment WHERE AssigneeId=:userId))
			AND (SobjectType ='ob1')];
			ObjectPermissions obj2=[SELECT PermissionsRead,PermissionsEdit,PermissionsDelete,PermissionsCreate
			                  FROM ObjectPermissions  where (ParentId IN (SELECT PermissionSetId FROM PermissionSetAssignment WHERE AssigneeId=:userId))
			AND (SobjectType ='ob2')];
			ObjectPermissions obj3=[SELECT PermissionsRead,PermissionsEdit,PermissionsDelete,PermissionsCreate
			                  FROM ObjectPermissions  where (ParentId IN (SELECT PermissionSetId FROM PermissionSetAssignment WHERE AssigneeId=:userId))
			AND (SobjectType ='ob3')];

// logic to chekc the permissions foor each objects

if user has permissions to all three object then return true else false.	
	
}
}

Can you please  tell me the better way to write Batch job? Also tell me ,  how may times i can run the Sceduler in a day?

 Thanks,

Dipak