Tag Archives: job schedule

SQL Jobs – Complete Information – SQL 2000/2005/2008/R2

SQL Job details – The script can be executed across all SQL version from SQL 2000 onwards. The below are the columns listed in the output ServerName ScheduleID ScheduleName IsEnabled ScheduleType Occurrence Recurrence Frequency ScheduleUsage StartDate ScheduleUsage EndDate ScheduleCreatedOn ScheduleLastModifiedOn … Continue reading

Posted in SQL | Tagged , , , | Leave a comment

SSRS – Identify a scheduled SSRS Report

Initiating subscription is a tedious task in SQL Server Reporting Services. Each subscription in Reporting Services is setup as a SQL Server Agent job, but the job names are Unique Identifier its hard to remember and re-call. Have complete information … Continue reading

Posted in SSRS | Tagged , , | 1 Comment