SQL Server 2000 and Managing Web Assistant Jobs

Remember, choosing to create your HTML page only once (at a specific time) or at regularly scheduled intervals, creates a scheduled task in SQL Server Agent.

Therefore, if you need to manage any aspect of a scheduled task created by the Web Assistant Wizard, you need to use the functionality of SQL Server Agent. From SQL Server Agent, you have the ability to create a new Web Assistant job, or start, stop, disable, get a history for, refresh, generate Transact-SQL scripts for, and delete or edit the properties for an existing Web Assistant job. For more in-depth information about managing SQL Server Agent jobs, see Chapter 12 on scheduling tasks.

Conversely, choosing to create your HTML page when ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.