snippet + sql-agent

Ever stepped back and looked at the enourmous barrage of unused SQL Agent Schedules? Clean them up!

A query that lists all SQL Agent jobs currently executing with their elapsed time.

The complete grant script for giving a user read-only SQL Server Agent visibility.

A query that decodes SQL Agent job history durations into real datetimes and seconds for sorting and analysis.

The complete grant script for giving a user full SQL Server Agent administration rights.