Troubleshooting: Permission error when running Multithreaded ETL Jobs

The following error may occur when a non-system administrative user runs an ETL Job using Multithreaded processing.

Non-Sysadmins have been denied permission to run CmdExec job steps without a proxy account.  The step failed.

Use the steps below to troubleshoot the error.

  1. Identify the owner of the Multithreaded Job.
    Go to Job Manager and select one of the system generated multithreaded jobs (Non PJP) and note the job owner, for example, NT AUTHORITY\SYSTEM.
  2. Add the job owner to the Sysadmin role.
    1. Connect to database server using SQL Server Management Studio.
    2. Go to Security and Server Roles.
    3. Select the Sysadmin role and add the job owner, for example NT AUTHORITY\SYSTEM.
  3. Continue Multithreaded Processing.
    In DWD Designer, access Background Jobs.
  4. Right-click PJP Job and select Continue from failed run.