SQL query on schedule - SQL Server Forums

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 Development (2000)

SQL query on schedule

Author

Topic

misterzr
Starting Member

49 Posts

Posted - 2006-02-15 : 10:15:48

I have a very simple SQL query that I have to run every day with the same parameters. Is there a way I can schedule this? This is running on our own SQL server in-house.

update	proddta.f41021 
set	lihcom = ''
from    proddta.f41021 inner join proddta.f4102 on liitm = ibitm
where	ltrim (limcu) = 'UP'
and     ltrim (ibmcu) = 'UP'
and	lilotn <> ''
and	lipqoh < '1'
and     ibstkt = 'S'
and	lipbin = 'S'
and	lihcom <> ''

mallier
Starting Member

24 Posts

Posted - 2006-02-15 : 11:00:51

Create new job,add this query into step and schedule it.

Enterprise manager-->SQL InstantName-->Managment-->Sql server Agent--> Jobs -- right click --> new job

cheers,
http://mallier.blogspot.com

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-02-15 : 11:04:42

I think there r 2 ways

1. U can Go to Enterprs Mngr --> management --> SQL Server Agent --> jobs
and create a new job in which u specify ur query and u can schedule it

2. Create a DTS package and do the same as above

3. I'm not sure but think there is a way as creating a Stored Proc and scheduling it. (Someone else in this forum will help u in this)

Edit :
I found an artical (there r a lot)
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58358

misterzr
Starting Member

49 Posts

Posted - 2006-02-15 : 12:21:22

Thanks for the help, this should do the job

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources