SQL Srver Job executing evern after disabling it

Question

I am migrating jobs from an old server to a new server and along with all the schedules and properties. The issue I am facing now is I have disabled jobs on the new server, but still, those jobs are getting executed and creating duplication issues. I have disabled all the jobs from the new server using GUI and have also check its status from "msdb.dbo.sysjobs" and it's showing as "0". Cannot figure out what is causing this issue.

I have an SSRS subscription that gets executed through an SSIS package and I have not scheduled an SSRS report subscription.

Answer 1

Hi @Harshal Patil ,

Please using below stored procedure to obtain status information about each job (this is actually what Job Activity Monitor uses). Please refer to sp_help_job (Transact-SQL) to understand the values of the columns.

exec msdb.dbo.sp_help_job  

Try to use below T-SQL to stop a job. Refer to sp_stop_job (Transact-SQL).

USE msdb  
GO  
EXEC dbo.sp_stop_job  
N'The name of the job'  

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.

Answer 2

Disabling the job only prevents it from running automatically via the schedule, NOT if something else starts the job.