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
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.