How do I start the failed jobs

Posted on 2009-04-29
Last Modified: 2013-11-05
Hello Friends,
Please help. We have some jobs scheduled daily and weekly in SQL server. Now some of the jobs fails. Now these jobs runs under "ustech" owner account. Now to run these jobs can i change the owner to "sa" , so that these jobs run. Let me know need help or show me some alternate solutions.
Question by:aatishpatel
    LVL 31

    Accepted Solution

    well, before your job working with "ustech" and now it don't so some settings are changed for login for sure. well, you can change job owner to "sa" and can watch whether it works or not. I guess, it should. but even if it don't work than do provide with the log so that further investigation possible.
    LVL 20

    Assisted Solution

    by:Marten Rune
    Yes you can.

    I would recommend SA as the job owner. It simplifies things.

    LVL 20

    Expert Comment

    by:Marten Rune
    Sorry, RiteshShah beat me to it.

    LVL 1

    Expert Comment

    ZAPE - way back in a prior life, I think that "SA" was not used because of some kind of security concerns. I am way out of date on this stuff, but it kind of rings a bell with me.
    No big thing, but just wanted to mention it.
    LVL 1

    Expert Comment

    ZAPE review requested.

    Improper comments deleted.

    @Experts - simply post a request for explanation from the Asker about why/how a question was closed. No need for any comments other than a simple question.

    If proper resolution is not forthcoming, any Member can always just click on the "Request Attention" link for some Moderator assistance.

    Experts Exchange Moderator

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now