I have a job that is identified in my log that I cannot seem to find, and then turn off.

What is the link between backupset and sysjobs?

I was hoping that I could see how this job was getting run, and disable it.

I have a weekly full and a nightly diff backup. This phantom job is doing a
full nightly, but I have no idea WHERE, HOW, and TO Where. I can see what it backed up in files :(

Lastly this is tagged by a particular individual, our Network Admin. so it
might be easy to find when it's the only entry by them in the user_name
column. This is the code to define my current dilemma. Any ideas?

select * from

dbo.backupset bus

left join dbo.backupmediaset bms

on bus.media_set_id = bms.media_set_id

where backup_start_date > '2006-06-25'

and user_name <> 'MYDomain\sqlservice'

and database_name = 'prod'



TIA