Is there a way to use a custom query when connecting to SQL server?  For example if we wanted to use a query to pull together a more succint view of the SQL Server agent job history rather than just grabbing the msdb.dbo.sysjobs_view table only.