Stored Procedures:

• Enumerate the SQL Agent logs files on the system (sp_sqlagent_enum_errorlogs)

• Read a SQL Agent log file (sp_sqlagent_read_errorlog)

• Rename SQL Agent (SQL Server 2000 only) (sp_sqlagent_rename)

• Auto start SQL Agent (SQL Server 2000 only) (sp_sqlagent_autostart)

• Set SQL Agent login and password for standard connection (SQL Server 2000 and Windows NT only) (sp_sqlagent_set_connection)

VB Scripts:

• Script jobs

Step samples:

• Using tokens in Active/X (VBScript) job step
• Using tokens in CmdExec job step
• Using tokens in T-SQL job step

Utilities:

• SQL Agent Job Manager - SQLJobMan

Articles and information:

• SQL Agent Recurring Job Schedules in Seconds
• Using SQL Agent Step Tokens
• SQL Agent Date and Time Handling
• How to fail or succeed a job step from a Visual Basic 6.0 program?
• List of Knowledge Base articles

Questions or problems regarding this web site should be directed to Web Master.
Copyright © 1991-2005 SQLDev.Net. All rights reserved.
Last modified: 04/06/05.