Search
 
SCRIPT & CODE EXAMPLE
 

SQL

hangfire clear all jobs

TRUNCATE TABLE [HangFire].[AggregatedCounter]
TRUNCATE TABLE [HangFire].[Counter]
TRUNCATE TABLE [HangFire].[JobParameter]
TRUNCATE TABLE [HangFire].[JobQueue]
TRUNCATE TABLE [HangFire].[List]
TRUNCATE TABLE [HangFire].[State]
DELETE FROM [HangFire].[Job]
DBCC CHECKIDENT ('[HangFire].[Job]', reseed, 0)
UPDATE [HangFire].[Hash] SET Value = 1 WHERE Field = 'LastJobId'
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql check db size 
Sql :: mysql last year 
Sql :: add unique constraint sql server multiple columns 
Sql :: mysql alter decimal precision 
Sql :: real world example of nosql 
Sql :: sql last updated 
Sql :: mysql reset root password 
Sql :: mysql error incompatible with sql_mode=only_full_group_by 
Sql :: how to remove default in mysql 
Sql :: datetrunc 
Sql :: this is incompatible with sql_mode=only_full_group_by laravel 
Sql :: oracle undo usage by session 
Sql :: MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES 
Sql :: Insert from table tsql 
Sql :: create unique index postgres 
Sql :: mysql how to change default charset 
Sql :: oracle pl sql source 
Sql :: pl sql disable trigger 
Sql :: concate update mysq 
Sql :: mysql change collation one column 
Sql :: how to add where command in update comand with joins 
Sql :: install postgresql centos 5 
Sql :: oracle trigger after connect 
Sql :: sql date get month 
Sql :: postgresql dump and restore db 
Sql :: backup a table in sql 
Sql :: postgres set column equal to another 
Sql :: database disk image is malformed sqlite fix ubuntu 
Sql :: mysql change password 
Sql :: postgresql set auto increment value 
ADD CONTENT
Topic
Content
Source link
Name
5+5 =