<div>
To get a more readable result set, follow the steps here: <br />
<a href="http://www.mssqltips.com/tip.asp?tip=1622" rel="ugc">http://www.mssqltips.com/tip.asp?tip=1622</a><br />
<br />
You create a function in msdb, then run a script against it. Results look something like this.<br />
<br />
name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;active_start_time &nbsp; &nbsp; &nbsp; ScheduleDscr<br />
SqlMon-4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0:00 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Automatically starts when SQLServerAgent starts.<br />
SqlMon All &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6:02 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Every day at 6:02<br />
SqlAudit - Scan &nbsp; &nbsp; 12:35 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Every 1 week(s) on Monday at 12:35<br />
<br />
<br />
&nbsp;<br />

</div>


To get a more readable result set, follow the steps here:
http://www.mssqltips.com/tip.asp?tip=1622 [http://www.mssqltips.com/tip.asp?tip=1622]

You create a function in msdb, then run a script against it. Results look something like this.

name                      active_start_time       ScheduleDscr
SqlMon-4                0:00                              Automatically starts when SQLServerAgent starts.
SqlMon All              6:02                              Every day at 6:02
SqlAudit - Scan     12:35                            Every 1 week(s) on Monday at 12:35


 


<div>
Thanks for the last post; it does make life a lot easier with this layout. &nbsp;I'm sorry I don't think/not sure I can split the points at this time.<br />
<br />
Kate
</div>


Thanks for the last post; it does make life a lot easier with this layout.  I'm sorry I don't think/not sure I can split the points at this time.

Kate

<div>
<div class="content wysiwyg-content">
Is there a way to get a list of all jobs and their schedules from the SQL Server Agent on SQL Server 2005?<br />
<br />
Thanks,<br />
Kate 
</div>
</div>


Is there a way to get a list of all jobs and their schedules from the SQL Server Agent on SQL Server 2005?

Thanks,
Kate 

Get a list of Job schedules in SQL Server 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.