Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to schedule a job to run a command once a month? Expand / Collapse
Posted Friday, August 3, 2012 9:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, August 5, 2012 1:17 PM
Points: 1, Visits: 3
Our vertex is installed on sql server 2008R2. Our security policy is that the password will expire every 30 days when the windows password expires. However, the vertex client that connects to the database requires a password too. Everytime, when the password expires, the vertex client will have an error. Once I exec sp_password @new='new_password', loginame='username' on master database, then the vertex client will work again. At this moment, I had set a reminder in my calendar to remember to issue this command on master database every month. I wonder if there is a job that I can schedule to run once a month so that it won't cause problem if I forgot to reset the password or I am on vacation. If so, what steps do I need to follow to set that job?

I tried to have the password never expire box checked, but it didn't work. I am relatively new to sql server. Any gurus out there have any ideas? Please advice. Thank you very much.
Post #1339930
Posted Sunday, August 5, 2012 7:18 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, November 20, 2016 3:52 AM
Points: 927, Visits: 2,039
You can schedule an agent job to run once per month, but it will still presemably require human intervention to update the password the job updates.

I'd spend some time figuring out why the "password not expire" option does not work.

Is the account a server account or domain account?
Does this vertex application have any service account configuration options?

I'm guessing it's a domain account so you may need to set it to not expire at both SQL server and active directory level.
Post #1340267
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse