Every so often people (network admins / developers / managers) as me when stuff is scheduled to run on the server. Generally they would like to know when they should schedule long running nightly processes in a timeframe that will not conflict with other nightly jobs.
Does someone have a friendly format for this type of information?
Some of the challenges I see are in interpreting the results of the system tables. i.e. Start/End Times recurring jobs etc.
I looked through the forms a bit but their is a lot of content about problems with jobs.
select j.originating_server, j.name, j.enabled as job_enabled, s.name as schedule_name, s.enabled as schedule_enabled, s.* from sysjobs j join sysjobschedules s on j.job_id = s.job_id