June 3, 2005 at 11:40 am
I have a very strange issue happening with one of one my SQL Servers (SQL 2000 SP3a). When I go into a job step and look at the type drop-down list, there is only one entry: Transact-SQL Script (TSQL). There should be several others like Operating System Command (CmdExec), Active X Script, etc. All the jobs on this server exhibit the exact same behavior. Does anyone know where this list gets populated from? Is it a system table? I need to have the job run a DTS package, but I can't set the type to the correct value. I have a work-around in that I can modify the sysjobsteps table directly, but I would really like to find out why the list isn't populating correctly.
Thanks in advance.
Ben
June 6, 2005 at 8:00 am
This was removed by the editor as SPAM
June 7, 2005 at 1:37 pm
I opened a trace, then opened the job step. It looks like it pulls the information from the msdb..sp_enum_sqlagent_subsystems stored procedure, which looks in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent\Subsystems. Check there and see what you have.
Good Luck!
June 13, 2005 at 2:29 pm
I was at Tech-Ed last week, so it has taken me a while to look into this again... When I go look for that key on the server, I get an Access is Denied error on the SQLServerAgent key. I'll have to look into why that key is corrupted.
Thanks for the help.
Ben
June 13, 2005 at 2:41 pm
Actually, the error is:
Cannot open SQLServerAgent: Error while opening key.
Definitely looks like a corruption problem...
Ben
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply