How to run sql select statement in sql job (sql 2000)

viki123

New Member

Join Date: Mar 2010

Posts: 9
#1

How to run sql select statement in sql job (sql 2000)

Apr 1 '10, 10:11 AM

i want to create sql job that runs a simple select query at specific time
Tags: None
Delerna

Recognized Expert Top Contributor

Join Date: Jan 2008

Posts: 1134
#2

Apr 8 '10, 06:58 AM

Create it as a DTS and then schedule the DTS to run at that specific time

Hang on...just reread the question

runs a simple select query at specific time

what exactly do you mean by that?
For what purpose?
Comment

Comment