SAP CCtr SC Import/Export jobs

[Former Member]

Greetings,

I've got a question about Import jobs. We've made a scheduled jop for importing. It's on a weekly basis and runs every sunday morning. What we'd like is, that if there is an error and the import job fails, an e-mail would be sent to an e-mail address with the error, so we could get right on it. Otherwise we would have to check it every monday.

If you have any suggestions on how to set a thing like this up, we would be very greatful.

Kind Regards,

Alder Tsvetkov

[former_member202106 · Accepted solution]

Hi Alder,

Good opening for the topic. At the moment there is no build in funtionality to do requested thing but I will generate some internal discussion around the topic.

As a workaround I would propose making simple code that polls config database and BatchJobServerJob table. You could for example follow field LastExecutionErrorCode, if value = 0 then the job finished succesfully and if something else then there is an issue. Based on the result you could trigger an email.

Regards,
Jukka

[Former Member · Accepted solution]

Hi,

Could you please clarify what the error codes mean? I know that if it "=0", the the job was a success. What do "=1" and "=2" mean? Or are there any other possible outcomes?

At the moment the notification that I've made, works as intended. I'm looking at the LastExecutionErrorCode. If it's ">0" then an e-mail will be sent. Thing is, that some job's come out with errorcode 2, status for the job is failed, an e-mail is sent, but when I look inside the job, I see no reason for the job to fail. Every thing looks fine and no errors are in it.

Kind Regards,

Alder Tsvetkov