Man's Best Friend with Benefits

A police officer named James, who turned to witchcraft after working a case with Sam and Dean, is plagued by nightmares in which he murders innocent people.