MS SQL Server - SQL Agent Job Steps only contain TRANSACT-SQL

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL Agent Job Steps only contain TRANSACT-SQL

JS Zullo

2006-03-27, 11:23 am

We run into a condition when the SQL Server 2000/Windows 2000 server has been
running for several days, that the EDIT JOB STEP Type drop down list only has
the Transact-sql option. Coincidentally, if I go to the JOB System Tab of the
SQL Agent properties, and try to change something, I get a message saying
changes can not be saved, out of resources. We then reboot the system and the
Job Type list is restored and I am able to save changes to the Job System
properties again.

I remember finding a post about this once long ago but haven't been able to
find it again. Does anyone know what causes this, and how it can be prevented?

Sponsored Links