SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to schedule a job to run a command once a month?


How to schedule a job to run a command once a month?

Author
Message
eileen.gu
eileen.gu
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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.
winston Smith
winston Smith
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1773 Visits: 2068
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search