Row Count resulting different on Scheduled Job x Background Scripts

[ana beatriz]

Why the count result on Scheduled Job is different from when running via Background Scripts?
I'm doing a count in a table and inserting the result on another table but the result is not right.

[Bert_c1]

Hi ana,

Post your script, and folks here can assist.  And how your Scheduled Job is defined, Is the 'Run as' value for that different from when run in Scripts Background?

[ana beatriz]

Hi Bert, the issue was related to the Run as, thank you very much!

[rexter1 · Accepted solution]

Check who is the "Run as" for you schedule job. Change it to your account you run the fix/background script. Should have the same result after.

[ana beatriz]

That is exactly what the issue was, thank you!