Apex Code Development You need to sign in to do that
Don't have an account?
linganna batch apex class run
hi all
iam getting the email but records not deleted and in developer console displaying
24.0 APEX_CODE,FINEST;APEX_PROFILING,INFO;CALLOUT,INFO;DB,INFO;SYSTEM,DEBUG;VALIDATION,INFO;VISUALFORCE,INFO;WORKFLOW,INFO
Execute Anonymous: Id batchinstanceid = database.executeBatch(new deleteAccounts('select Id from Account'),10);
23:39:01.051 (51627000)|EXECUTION_STARTED
23:39:01.051 (51640000)|CODE_UNIT_STARTED|[EXTERNAL]|execute_anonymous_apex
23:39:01.051 (51742000)|VARIABLE_SCOPE_BEGIN|[1]|batchinstanceid|Id|false|false
23:39:01.052 (52262000)|STATEMENT_EXECUTE|[1]
23:39:01.052 (52272000)|STATEMENT_EXECUTE|[1]
23:39:01.054 (54858000)|METHOD_ENTRY|[1]|01pU0000000xjRc|deleteAccounts.deleteAccounts()
23:39:01.054 (54869000)|STATEMENT_EXECUTE|[1]
23:39:01.055 (55004000)|SYSTEM_MODE_ENTER|false
23:39:01.055 (55021000)|HEAP_ALLOCATE|[1]|Bytes:5
23:39:01.055 (55030000)|STATEMENT_EXECUTE|[1]
23:39:01.055 (55039000)|SYSTEM_MODE_EXIT|false
23:39:01.055 (55049000)|METHOD_EXIT|[1]|deleteAccounts
23:39:01.055 (55069000)|HEAP_ALLOCATE|[1]|Bytes:8
23:39:01.055 (55078000)|HEAP_ALLOCATE|[1]|Bytes:22
23:39:01.055 (55121000)|CONSTRUCTOR_ENTRY|[1]|01pU0000000xjRc|(String)
23:39:01.055 (55158000)|VARIABLE_SCOPE_BEGIN|[4]|this|deleteAccounts|true|false
23:39:01.055 (55186000)|HEAP_ALLOCATE|[3]|Bytes:8
23:39:01.055 (55212000)|VARIABLE_ASSIGNMENT|[4]|this|{}|0x2cb7594f
23:39:01.055 (55221000)|VARIABLE_SCOPE_BEGIN|[4]|q|String|false|false
23:39:01.055 (55236000)|VARIABLE_ASSIGNMENT|[4]|q|"select Id from Accou (2 more) ..."
23:39:01.055 (55249000)|STATEMENT_EXECUTE|[1]
23:39:01.055 (55259000)|SYSTEM_MODE_ENTER|false
23:39:01.055 (55267000)|HEAP_ALLOCATE|[3]|Bytes:5
23:39:01.055 (55275000)|STATEMENT_EXECUTE|[3]
23:39:01.055 (55287000)|SYSTEM_MODE_EXIT|false
23:39:01.055 (55300000)|SYSTEM_MODE_ENTER|false
23:39:01.055 (55306000)|HEAP_ALLOCATE|[3]|Bytes:5
23:39:01.055 (55312000)|STATEMENT_EXECUTE|[5]
23:39:01.055 (55316000)|STATEMENT_EXECUTE|[6]
23:39:01.055 (55364000)|VARIABLE_ASSIGNMENT|[6]|this.Query|"select Id from Accou (2 more) ..."|0x2cb7594f
23:39:01.055 (55375000)|SYSTEM_MODE_EXIT|false
23:39:01.055 (55399000)|CONSTRUCTOR_EXIT|[1]|01pU0000000xjRc|(String)
23:39:01.055 (55431000)|SYSTEM_METHOD_ENTRY|[1]|Database.executeBatch(APEX_OBJECT, Integer)
23:39:01.101 (101186000)|HEAP_ALLOCATE|[1]|Bytes:15
23:39:01.101 (101206000)|SYSTEM_METHOD_EXIT|[1]|Database.executeBatch(APEX_OBJECT, Integer)
23:39:01.101 (101232000)|HEAP_ALLOCATE|[1]|Bytes:18
23:39:01.101 (101257000)|VARIABLE_ASSIGNMENT|[1]|batchinstanceid|"707U0000003azznIAA"
23:39:01.783 (104487000)|CUMULATIVE_LIMIT_USAGE
23:39:01.783|LIMIT_USAGE_FOR_NS|(default)|
Number of SOQL queries: 0 out of 100
Number of query rows: 0 out of 50000
Number of SOSL queries: 0 out of 20
Number of DML statements: 0 out of 150
Number of DML rows: 0 out of 10000
Number of script statements: 3 out of 200000
Maximum heap size: 0 out of 6000000
Number of callouts: 0 out of 10
Number of Email Invocations: 0 out of 10
Number of fields describes: 0 out of 100
Number of record type describes: 0 out of 100
Number of child relationships describes: 0 out of 100
Number of picklist describes: 0 out of 100
Number of future calls: 0 out of 10
23:39:01.783|CUMULATIVE_LIMIT_USAGE_END
23:39:01.104 (104521000)|CODE_UNIT_FINISHED|execute_anonymous_apex
23:39:01.104 (104529000)|EXECUTION_FINISHED
I think you'll need to post some code for us to help on this one.
global class deleteAccounts implements Database.Batchable<Sobject>
{
global final String Query;
global deleteAccounts(String q)
{
Query=q;
}
global Database.QueryLocator start(Database.BatchableContext BC)
{
return Database.getQueryLocator(query);
}
global void execute(Database.BatchableContext BC, List<SObject> scope)
{
List<Account> lstAccount = new list<Account>();
for (SObject s : scope) //for all objects from our query
{
Account a = (Account)s;
lstAccount.add(a);
}
Delete lstAccount;
}
global void finish(Database.BatchableContext BC)
{
//Send an email to the User after your batch completes
Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
String[] toAddresses = new String[] {'linganna09@gmail.com'};
mail.setToAddresses(toAddresses);
mail.setSubject('Apex Batch Job is done');
mail.setPlainTextBody('The batch Apex job processed ');
Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail });
}
}
The code looks fine. What does the query look like? You might also want to consider adding some debug statements to the execute method to check how many records are in the scope parameter.
Id batchinstanceid = database.executeBatch(new deleteAccounts('select Id from Account'),10);
i have written i system log page. i am gettin mail but records not deleted.
You log shows 0 DML statements, which implies that the delete isn't firing for some reason. Hence the suggestion of adding debug statements to the execute method to output the scope size and show the progress through the execute method.
Id batchinstanceid = database.executeBatch(new deleteAccounts('select Id from Account'),10);
i have written the above code in system log page. i am getting mail but records not deleted.
You've posted the same response again - was that intentional.
Hi linganna,
You have try like this. Its delete all account records
string query= [select id from account];
batchupdatefield batch=new batchupdatefield(query);
Database.executebatch(batch,200);
Thanks