I want to set ALL staff accounts to zero credit limit but at a set time.
I know I can do this either in Enterprise Manager or in the HQ Administrator but I want it to run automatically at a predefines time.
Does anyone know the best way to do this?
TIA
Sorry everyone,
Sorry I should have said, I know the SQL & have laready got the script prepared so just need guidence on how to get it to run at a set time
TIA (aga> I want to set ALL staff accounts to zero credit limit but at a set time. >
Sorry everyone,
Sorry I should have said, I know the SQL & have laready got the script prepared so just need guidence on how to get it to run at a set time
TIA (aga > I want to set ALL staff accounts to zero credit limit but at a set time. > > I know I can do this either in Enterprise Manager or in the HQ Administrator > but I want it to run automatically at a predefines time. > > Does anyone know the best way to do this? > > TIA
You can use the SQL Server Agent ... or the task scheduler of windows (running the script via osql)
cod
Have something to add? Share your thoughts — no account required.
Ask the community — no account required