January 12, 2011 at 5:15 pm
I've seen the forum postings saying that this comes from SQL Agent, but what specific tables is it testing from? What holds the parameters for the test?
The reason for this posting is that I have phantom jobs that run, but says the following:
JOB RUN:'Backup_WebReq_Log' was run on 1/12/2011 at 3:11:00 PM
DURATION:0 hours, 0 minutes, 0 seconds
STATUS: Failed
MESSAGES:The job failed. Unable to retrieve steps for job Backup_WebReq_Log.
There is no record of the entry in sysjobs, sysjobservers, sysjobsteps, so WHERE is it coming from?
In Profiler, the lines that move together are as follows:
SELECT N'Testing Connection...'
UPDATE msdb.dbo.sysjobactivity SET run_requested_date = DATEADD(ms, -DATEPART(ms, GetDate()), GetDate()), run_requested_source = 1, queued_date = NULL, start_execution_date = NULL, last_executed_step_id = NULL, last_executed_step_date = NULL, stop_execution_date = NULL, job_history_id = NULL, next_scheduled_run_date = NULL WHERE job_id = 0x42104DAC0D4B9144BEEBD1522712CB8B and session_id = 62
January 12, 2011 at 5:29 pm
Do you possibly have another server that is running the job?
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
January 12, 2011 at 5:35 pm
That would have been nice. I suspect that somewhere there is an orphaned job ID in a sys table that has information that is on it's own. I just don't know where to look for it.
January 12, 2011 at 5:40 pm
Have you run: SELECT name, job_id from msdb.dbo.sysjobs where name = 'Backup_WebReq_Log' ?
Possibly check all your SQL Servers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
January 12, 2011 at 5:54 pm
You may also want to run this: select * from sysjobhistory
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
January 13, 2011 at 9:21 am
That was a good one, Leo, but it only showed the successful job. The "orphans" are not appearing.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply