question

I have deleted the database, removed log shipping of the database and its respective job but the job still runs, the secondary server LSAlert_devwinsql4 job error Message > Executed as user: NT AUTHORITY\NETWORK SERVICE. The log shipping secondary database DEVWINSQL4.RE7 has restore threshold of 45 minutes and is out of sync. No restore was performed for 5850 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14421). The step failed. Why do I see the error message, if there is no job and database does not exist. I have also executed the following statements: delete from msdb.dbo.log_shipping_primary_databases delete from msdb.dbo.log_shipping_primary_secondaries delete from msdb.dbo.log_shipping_monitor_primary delete from msdb.dbo.log_shipping_monitor_history_detail delete from msdb.dbo.log_shipping_monitor_error_detail delete from msdb.dbo.log_shipping_monitor_alert