Hi guys, I need your help on this. I have an SQL Server that I use for reporting. Every morning at 4:45am, I have a job that loads data from my LIVE ERP system into my SQL Server. For a few months, the same jobs starts at around 11pm. I checked all my SQL Server instances and found no jobs or schedule like this. I also looked into a few system tables, but cannot find the source of this. I really need to be able to stop this job as it is taking resources and logs space for nothing. Can you please help me troubleshoot this so I can find where it is coming from ? Thanks PS : no idea of when it exactly started and what happened for this to happen BR Marc
asked Jul 06, 2015 at 10:05 AM in Default
It sounds like something other than the schedule is running the job, most likely using msdb.dbo.sp_start_job. It must be using either the job_name or job_id to start the job. If you change both of those it will stop. Here's what I would do:
I'd be surprised if this mystery thing can run the job after that.
I would also review security. Which accounts have permissions to run jobs? Should they have those permissions?