Remove entries in the Sitecore Publishing Service queue using PowerShell.

CleanupTables.sql

Import-Function -Name Invoke-SqlCommand

$connection = [Sitecore.Configuration.Settings]::GetConnectionString("master")

$query = @"
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_ActivationLock]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_Data_Params_FieldIds]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_Data_Params_Languages]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_JobManifest]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_JobMetadata]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_JobQueue]
DELETE TOP(100000) FROM [Sitecore.Masterx].[dbo].[Publishing_ManifestOperationResult]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_ManifestStatus]
DELETE TOP(100000) FROM [Sitecore.Masterx].[dbo].[Publishing_ManifestStep]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_PublisherOperation]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_TargetSyncState]
"@
Invoke-SqlCommand -Connection $connection -Query $query

DeleteFromPublishingJobQueue.ps1

Import-Function -Name Invoke-SqlCommand

$connection = [Sitecore.Configuration.Settings]::GetConnectionString("master")

$query = @"
  DELETE TOP (1000)
  FROM [dbo].[Publishing_JobQueue]
  SELECT COUNT(*) QueueCount
  FROM [dbo].[Publishing_JobQueue]
"@
$records = Invoke-SqlCommand -Connection $connection -Query $query

DeleteFromPublishingJobQueue2.ps1

Import-Function -Name Invoke-SqlCommand

$connection = [Sitecore.Configuration.Settings]::GetConnectionString("master")

$query = @"
  SELECT COUNT(*) AS QueueCount
  --DELETE TOP (1000)
  FROM [dbo].[Publishing_JobQueue]
  WHERE CAST([Options] as nvarchar(max)) LIKE '%<a:Value>sitecore\Anonymous</a:Value>%'
"@
Invoke-SqlCommand -Connection $connection -Query $query