Related Documentation › Cancel a Running MSSQL Server Job

Cancel a Running MSSQL Server Job

You can cancel a running MSSQL Server job.

Follow these steps:

1. Right-click the MSSQL Server job in the Monitor perspective.

   A list of job commands appears.

2. Select Cancel Job.

   The Cancel Job dialog opens.

3. (Optional) Enter the command reason in the Reason field.

   Limit: 1024 characters (including the timestamp and the user name)

   Note: We recommend that the reason text not exceed 250 characters. The number of commands displayed in the command log is limited to the size of the command log buffer, which is 1024 characters. For example, if the reason text averages 10 characters per command, the command log displays up to 50 commands; if the reason text averages 250 characters per command, the command log displays up to 4 commands.

4. Click OK.

   The server cancels the running MSSQL Server job.