2

I'm using SQL Server 2008 and trying to make schedule to run a page every mid-night but I don't know how to do it. I already tried to do with SQL JOBS but couldn't find JOB folder.

Joel Coehoorn
  • 399,467
  • 113
  • 570
  • 794
Jay
  • 1,384
  • 1
  • 17
  • 30

2 Answers2

4

If you are using a full SQL Server product (not Express), just follow the steps from Books Online

http://msdn.microsoft.com/en-us/library/ms191439%28v=SQL.100%29.aspx

FYI - The folder "Jobs" is under "SQL Server Agent" in the Object Explorer tree.

If you are asking about Express, then refer to answers in this SO question or a neat trick using SQL Server Service Broker

Community
  • 1
  • 1
RichardTheKiwi
  • 105,798
  • 26
  • 196
  • 262
  • The SQL version is Express Edition with Advanced and its 2008 not 2005. Do you think its gonna work on 2008 as well? – Jay Jan 17 '11 at 03:01
  • 2
    The techniques linked work with 2008 (and R2 for that matter) as well as 2005. Personally, I prefer the simple scheduling of SQLCMD.exe using Windows Task Scheduler. – RichardTheKiwi Jan 17 '11 at 03:11
  • I just used Windows Task Scheduler. It works fine. Thanks a lot. – Jay Jan 17 '11 at 05:35
  • Great to see the problem solved. Welcome to stackoverflow. When you are happy with an answer (you can always wait indefinitely for more suggestions), please tick one off as the answer. Cheers – RichardTheKiwi Jan 17 '11 at 09:43
0

to schedule PAGE (script) running look in Task Manager