Home Forums Article Discussions Article Discussions by Author Discuss content posted by Michael Abair SQL Server Agent Schedule Decoder RE: SQL Server Agent Schedule Decoder

  • January 6, 2010 at 8:27 am

    #1099623

    c.masca (1/6/2010)

    Thanks for the script - it lists scheduling info, but lists the job name as is. Would it be possible to also 'decrypt' the job name, somehow. we have a large number of reporting-services-generated jobs whose name are gibberish. It would be great if the job name could be translated to show the name of the RS schedule that the job represents. So far, I have been unable to decipher this type of job names.

    You could join job_name to ScheduleID in the Schedule table in the ReportServer database to retrieve Name and EventType.