PRB: Four-Digit Year Expected When Scheduling Tasks or Jobs

ID: Q219408

The information in this article applies to:

Microsoft SQL Server versions 6.0, 6.5, 7.0

SYMPTOMS

A four-digit year format is expected when scheduling a task or job through Enterprise Manager, sp_addtask, sp_updatetask, sp_add_jobschedule (7.0), and sp_update_jobschedule (7.0). The date is utilized exactly as input and no conversion occurs on the date. For example, if the user enters 01 for the year, the year is interpreted as 0001, not 2001.

CAUSE

Since four digits are expected, 0000 - 9999 are valid input values.

RESOLUTION

Enter the complete four digit year.

MORE INFORMATION

This applies to any task for which the user can set a schedule, such as:

Backup

Transfer manager (6.5) / DTS (7.0)

Task / job management

REFERENCES

For more information about how Microsoft products are affected by year 2000 (Y2K) issues, please see the following Microsoft World Wide Web site:

http://www.microsoft.com/y2k/

Additional query words: Y2K KB2000 Y2Kreviewed

Keywords : kbSQLServ600 kbSQLServ650 kbSQLServ700
Version : winnt:6.0,6.5,7.0
Platform : winnt
Issue type : kbprb