You Asked
Hi,
I know that there was one question about Apex automation successfull rows. But it was very basic example.
I have a procedure that performs some DML operations inside a loop. Depending on certain conditions, it updates or deletes rows.
My question/use case is:
Is there a way to count how many rows were updated and deleted within this procedure, and then display that count as the Successful Rows value in the APEX Automation log?
So far, I managed to write log messages (info or warn), but the values only appear as text messages in the Message column — not as the numeric count of successful rows.
Thanks in advance!
and Connor said...
Not to my knowledge.
The successful/error counts are for automations of type "Query", ie, the automation itself knows about the DML.
If you're running a procedure, then the automation is synonymous with a standard scheduler job, so you'd need to log the content you want to keep yourself.