Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Script to execute at certain time

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-11-29 : 09:41:12
Faraz writes "Hi
I want to write a script, that exports data into a csv file (this is no problem). However I want this to be done, at a cerain time of a day, when I am not at work maybe. Is it possible to to write a script that specifies the date and time of execution. Or a script that I can run, which pauses for X hours and then starts executing?

Thank you
Faraz"

nr
SQLTeam MVY

12543 Posts

Posted - 2002-11-29 : 09:55:41
You can do any of these.
Easiest is to create a job which executes daily at a specific time and executes the script.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -