In the Job Properties dialog, click the Steps page, and then click New.

In the New Job Step dialog, type a job Step name.

In the Type list, click PowerShell.

In the Run as list, select the proxy account with the credentials that the job will use.

In the Command box, enter the PowerShell script syntax that will be executed for the job step. Alternately, click Open and select a file containing the script syntax.

Click the Advanced page to set the following job step options: what action to take if the job step succeeds or fails, how many times SQL Server Agent should try to execute the job step, and how often retry attempts should be made.