Scheduling with the SQL Server Agent A few practical examples on setting up policies. This time, we PowerShell it. By Joshua Jones 12/07/2009 It is possible to use the SQL Server Agent to execute ...

This would typically be the SQL Server Agent service account. However, by default this account runs with the privileges of a domain user rather than with higher-level system privileges, Microsoft ...

It is also worth mentioning the other two SQL Agent roles available in SQL Server 2005. The SQLAgentUserRole allows users to create jobs and to manage the jobs that they create.

That means that if you intend to execute PowerShell scripts/commands from SQL Agent Job steps, the service account that the SQL Server Agent is running as must have appropriate permissions.