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.
aatishpatelAsked:
Who is Participating?
 
RiteshShahConnect With a Mentor Commented:
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 RuneConnect With a Mentor SQL Expert/Infrastructure ArchitectCommented:
Yes you can.

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

/Marten
0
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
Sorry, RiteshShah beat me to it.

/Marten
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.