SQL Agent

How can I make use of the SQL Agent Job Scheduling Service ? Is this possible? I was reading a half year ago that is a online tool but my recent searches have much succes...

 

Search those topicsin SQL Server Books on-line.
Assuming you have a local copy of SQL Server you can create DTS packages to schedule and run tasks.
You couldalso run queries in that package to pumpdata to and from your remote SQL Server.

 

and assumming I have only Express Edition supplied with Vista ... which doesn`t support such service and I had attached a MDF from App_Data ...
Connecting through SQL Server Management Studio Express come`s with errors and I`m not able to access and manage that remote DB ...

I`m aware of the DTS methodology but I was wandering of existence ofsome sort of on-line tool since I can`t run queries on the MDF.

Post Edited (SoulBlight) : 11/5/2007 12:43:20 PM GMT

 

From my own opinions, experiences, you'll do best to get a developer version of SQL Server.
Either SQL Server 2000 or 2005 will work for the accounts here.
You can get them for under $50 on-line and you'll definitely thank yourself.

 

Anyone ...

 

OK.


I know that this is a permission issue.


Msg 229, Level 14, State 5, Procedure sp_add_job, Line 1


The EXECUTE permission was denied on the object 'sp_add_job', database 'msdb', schema 'dbo'.


The original DTS is:


use msdb;


go


exec sp_add_job @job_name = 'Daily Reservation';


go


It was run as a simple Query on my Database hosted here

</A>Can someonetell me if I can create Jobs and schedule them on SQL Serververs provided by DiscountAsp ...