none
SQL Agent not running on scheduled time.

    Question

  • I have create to agent jobs in sql 2008R2 to copy database on another server in network it runs porper for few days after that suddenly from last 2 days its not working. 

    Akshay Pate Server Administrator

    Saturday, October 12, 2013 6:26 AM

Answers

  • Hello,

    Any error you got ,maybe.Please post it


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Marked as answer by Akshay Pate Saturday, October 12, 2013 6:35 AM
    Saturday, October 12, 2013 6:34 AM
  • Check if SQL Server Agent service started and running now? (from SQL Server Configuration Manager)

    Saeid Hasani, sqldevelop.wordpress.com

    Download Books Online for SQL Server 2012


    • Edited by Saeid Hasani Saturday, October 12, 2013 7:10 AM
    • Marked as answer by Akshay Pate Saturday, October 12, 2013 7:12 AM
    Saturday, October 12, 2013 7:09 AM
  • Please, ensure that SQL Server Agent is started on the destination server.

    More info:

    Use the Copy Database Wizard


    Saeid Hasani, sqldevelop.wordpress.com

    Download Books Online for SQL Server 2012

    • Marked as answer by Akshay Pate Saturday, October 12, 2013 7:29 AM
    Saturday, October 12, 2013 7:27 AM
  • I have not found any error. i have checked event viewer and sql error also.

    sorry i have found errors. Please see below.

    ==============================================

    Date 10/11/2013 2:04:10 AM
    Log SQL Server Agent (Archive #2 - 10/11/2013 2:04:00 AM)

    Message
    [298] SQLServer Error: 773, SQL Server Network Interfaces: The requested security package does not exist [SQLSTATE 08001]

    ==============================================



    Akshay Pate Server Administrator


    Hello ,

    Since you said SQL server agent is started it surely seems to me as account with which SQL server service is running .Can you tell me what account you are using ,seems to me as Network service account .

    It would be good if you create a domain account and give it complete privileges on local server and run the SQL agent with that account .

    Are you running copy database through SSIS package?


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Marked as answer by Akshay Pate Saturday, October 12, 2013 7:39 AM
    Saturday, October 12, 2013 7:35 AM
  • Yes agent service is in running state on source and destination server. i guess i just get error on opening of sql server configuration manager is giving below error.

    Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"

    i guess above error was causing issue.


    Akshay Pate Server Administrator


    • Edited by Akshay Pate Saturday, October 12, 2013 7:35 AM
    • Marked as answer by Akshay Pate Saturday, October 12, 2013 7:48 AM
    Saturday, October 12, 2013 7:35 AM
  • Yes agent service is in running state on source and destination server. i guess i just get error on opening of sql server configuration manager is giving below error.

    Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"

    i guess above error was causing issue.


    Akshay Pate Server Administrator


    Hello ,

    Please only mark answers which really solve your issue ,i am very thankful to your feedback but marking correct answer will help other readers to get benefit from it.

    Now please see this link for above error,is this applicable to your scenario ? .Please reply if your issue is not solved

    http://support.microsoft.com/kb/956013


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Marked as answer by Akshay Pate Saturday, October 12, 2013 7:47 AM
    Saturday, October 12, 2013 7:43 AM
  • Therefore, you can see this link:

    SQL Server 2005 says : ‘Cannot connect to WMI provider’


    Saeid Hasani, sqldevelop.wordpress.com

    Download Books Online for SQL Server 2012

    • Marked as answer by Akshay Pate Saturday, October 12, 2013 7:47 AM
    Saturday, October 12, 2013 7:45 AM

All replies

  • Hello,

    Any error you got ,maybe.Please post it


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Marked as answer by Akshay Pate Saturday, October 12, 2013 6:35 AM
    Saturday, October 12, 2013 6:34 AM
  • I have not found any error. i have checked event viewer and sql error also.

    sorry i have found errors. Please see below.

    ==============================================

    Date 10/11/2013 2:04:10 AM
    Log SQL Server Agent (Archive #2 - 10/11/2013 2:04:00 AM)

    Message
    [298] SQLServer Error: 773, SQL Server Network Interfaces: The requested security package does not exist [SQLSTATE 08001]

    ==============================================



    Akshay Pate Server Administrator


    • Edited by Akshay Pate Saturday, October 12, 2013 6:42 AM
    Saturday, October 12, 2013 6:36 AM
  • Check if SQL Server Agent service started and running now? (from SQL Server Configuration Manager)

    Saeid Hasani, sqldevelop.wordpress.com

    Download Books Online for SQL Server 2012


    • Edited by Saeid Hasani Saturday, October 12, 2013 7:10 AM
    • Marked as answer by Akshay Pate Saturday, October 12, 2013 7:12 AM
    Saturday, October 12, 2013 7:09 AM
  • I have checked and service are running on source server.


    Akshay Pate

    Server Administrator


    • Edited by Akshay Pate Saturday, October 12, 2013 7:21 AM
    Saturday, October 12, 2013 7:13 AM
  • Please, ensure that SQL Server Agent is started on the destination server.

    More info:

    Use the Copy Database Wizard


    Saeid Hasani, sqldevelop.wordpress.com

    Download Books Online for SQL Server 2012

    • Marked as answer by Akshay Pate Saturday, October 12, 2013 7:29 AM
    Saturday, October 12, 2013 7:27 AM
  • I have not found any error. i have checked event viewer and sql error also.

    sorry i have found errors. Please see below.

    ==============================================

    Date 10/11/2013 2:04:10 AM
    Log SQL Server Agent (Archive #2 - 10/11/2013 2:04:00 AM)

    Message
    [298] SQLServer Error: 773, SQL Server Network Interfaces: The requested security package does not exist [SQLSTATE 08001]

    ==============================================



    Akshay Pate Server Administrator


    Hello ,

    Since you said SQL server agent is started it surely seems to me as account with which SQL server service is running .Can you tell me what account you are using ,seems to me as Network service account .

    It would be good if you create a domain account and give it complete privileges on local server and run the SQL agent with that account .

    Are you running copy database through SSIS package?


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Marked as answer by Akshay Pate Saturday, October 12, 2013 7:39 AM
    Saturday, October 12, 2013 7:35 AM
  • Yes agent service is in running state on source and destination server. i guess i just get error on opening of sql server configuration manager is giving below error.

    Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"

    i guess above error was causing issue.


    Akshay Pate Server Administrator


    • Edited by Akshay Pate Saturday, October 12, 2013 7:35 AM
    • Marked as answer by Akshay Pate Saturday, October 12, 2013 7:48 AM
    Saturday, October 12, 2013 7:35 AM
  • Yes agent service is in running state on source and destination server. i guess i just get error on opening of sql server configuration manager is giving below error.

    Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"

    i guess above error was causing issue.


    Akshay Pate Server Administrator


    Hello ,

    Please only mark answers which really solve your issue ,i am very thankful to your feedback but marking correct answer will help other readers to get benefit from it.

    Now please see this link for above error,is this applicable to your scenario ? .Please reply if your issue is not solved

    http://support.microsoft.com/kb/956013


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Marked as answer by Akshay Pate Saturday, October 12, 2013 7:47 AM
    Saturday, October 12, 2013 7:43 AM
  • Therefore, you can see this link:

    SQL Server 2005 says : ‘Cannot connect to WMI provider’


    Saeid Hasani, sqldevelop.wordpress.com

    Download Books Online for SQL Server 2012

    • Marked as answer by Akshay Pate Saturday, October 12, 2013 7:47 AM
    Saturday, October 12, 2013 7:45 AM
  • on source server is running with domain account. Destination server is not connected to domain it get only IP address from DHCP and nothing more than. I guess i am doing that with SSIS as you says above. Please see below image for more details.


    Akshay Pate Server Administrator

    Saturday, October 12, 2013 7:45 AM
  • while posting ticket to forums i have googled it and solve it at own. but many thanks for sharing link for such error

    Akshay Pate Server Administrator

    Saturday, October 12, 2013 7:48 AM
  • while posting ticket to forums i have googled it and solve it at own. but many thanks for sharing link for such error.

    Akshay Pate Server Administrator

    Saturday, October 12, 2013 7:49 AM
  • while posting ticket to forums i have googled it and solve it at own. but many thanks for sharing link for such error.

    Akshay Pate Server Administrator

    Hello ,

    Can you share what solution you got which solved the issue.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Saturday, October 12, 2013 7:52 AM
  • I do same what you gave me in link. http://support.microsoft.com/kb/956013

    sql server configuration manager issue is resolved not copy database wizard.


    Akshay Pate Server Administrator

    Saturday, October 12, 2013 8:00 AM
  • I do same what you gave me in link. http://support.microsoft.com/kb/956013

    sql server configuration manager issue is resolved not copy database wizard.


    Akshay Pate Server Administrator

    Thanks for feedback.For SSIS package Copy Db wizard error seems to be related to SSIS please raise new thread in SSIS forum.Also again I will appreciate if you could only mark answer which really solved issue.

    Thanx for feedback and visiting the forum


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Saturday, October 12, 2013 8:12 AM
  • Thanks Shanky, 

    Your comment was full of finesse!


    Saeid Hasani, sqldevelop.wordpress.com

    Download Books Online for SQL Server 2012

    Saturday, October 12, 2013 8:33 AM
  • Thanks Shanky, 

    Your comment was full of finesse!


    Saeid Hasani, sqldevelop.wordpress.com

    Download Books Online for SQL Server 2012

    Thax Saeid ,

    Just trying to make forum better place :)


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Saturday, October 12, 2013 11:05 AM