Post reply

can't see agent job properties

  • June 2, 2011 at 11:48 am

    #239149

    I am running SQL Server 2005 with SP4, and I am a am using sysadm account, I can create a run a job but can't scee the job name and properties.

    I already run the regsvr32.exe dts.dll but still can not see the job. I can run it.

    I am running window 2003 SP2.

  • June 2, 2011 at 1:17 pm

    #1333323

    any idea please

  • June 3, 2011 at 7:21 am

    #1333671

    Hi,

    Is it possible that you have the SQLAgent down which wont allow you to view jobs in SSMS ?

    In such a case you will be able to create Maintenance Plan (which has associated jobs) but not see the jobs created.

    Can you post more on the issue and/or if any error seen at the time ?

    Thanks,

    Ninad Soman

  • June 3, 2011 at 7:31 am

    #1333677

    Thanks for reply,

    I have a same issue with Maintenance Plan too, first I have SP3 so I install SP4 but issue is stil there. it is not on work station i am working on server.

    if you need any other information pl let me know Thanks

  • June 3, 2011 at 7:46 am

    #1333685

    It can be a case of sp4 not applied properly..

    When we apply sp4 it asks for the areas to which it should apply...

    If u can remember were all areas selected?

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • June 3, 2011 at 8:00 am

    #1333696

    yes, but i have a same issue with sp3 so I install sp4 but no luck

  • June 3, 2011 at 8:28 am

    #1333714

    wat edition of sql server are you having,, imean enterprise/express/..?

    Regards
    Sushant Kumar
    MCTS,MCP

  • June 3, 2011 at 8:31 am

    #1333720

    2005 enterprise

  • June 3, 2011 at 8:43 am

    #1333734

    This issue happens when you RD into server or sql locally?

    Check both cases

    Regards
    Sushant Kumar
    MCTS,MCP

  • June 3, 2011 at 8:44 am

    #1333736

    Hi,

    Can you check the installation summary file ?

    You can find it probably at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

    also check if any error logged for SQL ..

  • June 3, 2011 at 9:20 am

    #1333757

    Thanks for reply

    I am RD to the server, so how to fix the problem

    also i check the log only error I found is

    Registry: Cannot read registry key value "PendingFileRenameOperations", error 1421

    I no need to install NotificationServices servers

  • June 3, 2011 at 9:29 am

    #1333764

    The only problem i guess is that the client components are installed after the sp2/sp3 installation..

    Look out this forum...it should help u:--

    http://www.sqlservercentral.com/Forums/Topic353013-146-1.aspx

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • June 3, 2011 at 9:54 am

    #1333774

    No, SP2, SP3 is not fix my issue, any other solution please

    I did install all that SQL Sever component all together including client

  • June 3, 2011 at 10:20 am

    #1333790

    Hi,

    What is the OS on which you have SQL installed ?

    are you able to use all other features/functaionality of SQL Enterprise w/o any problems ? or this is just with the SQL Agent ?

    Thanks,

    Ninad

  • June 3, 2011 at 10:27 am

    #1333798

    What is the OS on which you have SQL installed ?

    are you able to use all other features/functaionality of SQL Enterprise w/o any problems ? or this is just with the SQL Agent ?

    We are running Window 2003 SP2 shop with SQL Server 2005 Ent. SP4 then SP4 install, all others features and working db is connected with web application and all other application are working fine

Viewing 15 posts - 1 through 15 (of 25 total)

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