SQL Server 2005, I'm seeing about 100 'jobs' in the SQL Agent>jobs node in SSMS. They appear as hexadecimal strings not with their real names:
If I query msdb..sysjobs, I see a much smaller list of jobs and their corresponding JobName.
So what are these jobs and how can I make them appear as their real job name as opposed to the JobID?
Thanks,
Peter
Best Answer
They are from reporting service subscriptions.
Below SQL will give you list of the job names against the actual reports
Even better (got it from this link):