Sql jobs are not getting disabled

I have a server set for both mirroring  and log shipping on different server. Due to patching we have fail over from secondary server to principle,now log shipping job is not getting disabled.Means even after disabling jobs it get enabled automatically.
I have updated the sysjob table as well, but no luck.Please assist
LVL 5
VIVEKANANDHAN_PERIASAMYAsked:
Who is Participating?
 
TempDBAConnect With a Mentor Commented:
You can disable the schedule of the job.
Or if there is no shcedule, then there must be something that is triggereing the job. Check any manually script or any other job is there which checks whether it is disabled and then triggers it.
You can also check in the history that it was invoked by what.
0
 
VIVEKANANDHAN_PERIASAMYAuthor Commented:
This is the output I got:
Executed as user: NT AUTHORITY\NETWORK SERVICE. The log shipping primary database servername.databasename has backup threshold of 60 minutes and has not performed a backup log operation for 35026 minutes. Check agent log and logshipping monitor information. [SQLSTATE 42000] (Error 14420).  NOTE: The step was retried the requested number of times (3) without succeeding.  The step failed.
0
 
AlokJain0412Commented:
Hi,

Execute below statement in monitor server. Statement will remove alert job.

sp_delete_log_shipping_alert_job

links helpful
http://msdn.microsoft.com/en-us/library/ms189071.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.