• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

How do I start the failed jobs

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.
0
aatishpatel
Asked:
aatishpatel
2 Solutions
 
RiteshShahCommented:
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.
0
 
Marten RuneCommented:
Yes you can.

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

/Marten
0
 
Marten RuneCommented:
Sorry, RiteshShah beat me to it.

/Marten
0
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
Vee_ModCommented:
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.
Thanks,
VM
0
 
Vee_ModCommented:
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.

Vee_Mod
Experts Exchange Moderator
http://www.experts-exchange.com/Q_24391547.html
0
 
aatishpatelAuthor Commented:
thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now