QUERY > Approving and rejecting files > Approving, rejecting, and reassigning query files

Back to

Approving and rejecting files

Approving, rejecting, and reassigning query files

Production and Nonproduction servers

Your system consists of one or more production and nonproduction servers. Access to production servers tends to be restricted, whereas access to nonproduction servers is less restricted because a nonproduction server can serve as a test platform.

You can run a query on a nonproduction server whether or not it has been approved.

System usage level

When you submit a query file for approval, the file reviewer applies a system usage level. A system usage level describes level of system resources that a query might consume during a query execution. A system usage level is assigned to the policy that is assigned to your user name, and controls the level of queries that you can run on a server at a given time. If the usage level of the script conflicts with the usage level of the server that you are assigned to use, the file cannot run.

Bypass the query file approval workflow

If your CENTRAL administrator removes the approval requirement, all queries can be created and run without first being approved.

Running a query to test it

To test a query, a reviewer can run a query on a production server.

Approving and rejecting files

To approve or reject a file

  1. On Winshuttle Central, in the Tasks Details window, click the file name.
  2. If supporting documents are available for the file, click View attachments to see them.
  3. The Review Tasks window, click Approve or Reject. If you want, add a comment to explain why you have approved or rejected the file. Click Complete Task. Note: if you are reviewer, you must either close the client and reopen it, or open the file from within Excel.
  4. If you want, change the System Usage Level for that file.

To reassign a file

  1. On Winshuttle Central, in the Tasks Details window, click the file name.
  2. The Review Tasks window, click Reassign.
  3. Select the user that you want to reassign the file to. If you want, add a comment. Click Complete Task.

Approving your own queries

If you have a developer, reviewer, and runner role, and if self-approval is enabled by the administrator, you can submit and approve your own query files, and then run them on the production server.

Reassigning files

Once a query file has been submitted for review, the file can be reassigned to another reviewer.

To reassign a file

  1. In the Review Tasks window, click Reassign.
  2. Select the user that you want to reassign the file to. If you want, add a comment. Click Complete Task.

Running files that are part of a review process

To run a file

  1. Verify that the file that you want to run is marked Approved.
  2. Click Run . For more information about running files, see Running.

Viewing information about files

To view more information about files

Also in this section

Sending a file for approval