Your limits are the same as they would be if it was a client application calling the database. INSERT/UPDATE/DELETE will cause blocking. SELECT with poor or improper code can lead to scans. All this needs memory, cpu and I/O and you can bottleneck on those resources depending on what you're doing. There's nothing magic, good or bad, about calling from SQL Agent.