Unable to view Job Properties

Question

Post reply

Unable to view Job Properties

The_SQL_DBA

SSChampion

Points: 10494
More actions
November 6, 2008 at 7:34 am

#127562

We need to move a DB on Server A to Server B. I am doing a backup and restore. I started with a test restore and was successful. I did not script the jobs, instead I re-created them on Server B and ran them successfully. But I am unable to view the properties for any job .I get the following error :unsure:
To run the jobs also I had to enable xp_cmdshell and ole automated stored proc's as it is a newly built server hosting the SQL 2005 Standard Edition on SP2.
Thanks in Advance!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 1

Any views will be appreciated..Thanks!!

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

SanjayAttray SSChampion Points: 13157 More actions · Answer 2

xp_cmdshell is by default disabled in SQL server 2005 unlike SQL Server 2000. You have to enable it by Sp_configure or by configuration manager.

EXEC master.dbo.sp_configure 'show advanced options', 1

RECONFIGURE

EXEC master.dbo.sp_configure 'xp_cmdshell', 1

RECONFIGURE

and for Ole Automation Procedures run this:

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Ole Automation Procedures', 1;

GO

RECONFIGURE;

GO

SQL DBA.

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 3

I ran the above statements you mentioned before running the jobs. I am not sure if I was able to view the job properties before enabling the above procedures. Do I need to revert back? Still not able to view the job properties, I can run them successfully though..

Thanks!!

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 4

Does anyone know if this calls for re-installation of SQL server or is there any hotfix for such an issue, because the server is on SP2 at this time. The issue still is that I am unable to view the job properties. The error is uploaded in the attachments..

Thanks!!

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."