remove traces of any redundant secondary databases on the secondary server using
USE master;
go
exec sp_delete_log_shipping_secondary_database
@secondary_database = 'secondary_database';
Once you're sure any LS scenarios have been cleared remove the alert job using
USE master;
GO
EXEC sp_delete_log_shipping_alert_job;
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉