SQL Agents

[Guest]

Hi,
Quick question. Are we allowed to run custom agents on our remote SQL database?

Thanks

[wisemx]

Hi,
You can connect from your local side adding the DASP SQL Servers to your own.
There are no SSIS tools on the Web edition of SQL Server and the Agent has to run on your end.
In current or previous SQL Server studios you can however easily add your DASP servers.
Make sense? ;-)
All the best,
Mark

[Guest]

Hi,
Original poster here. I think I understand. I simply fire up Management studio, connect to my DASP server and run the agents (locally) on the remote server?
If that's the case, then that sounds okay. If it's not, I might need some clarification :)!
Thanks for the reply

[Guest]

Sorry, above sentence was a bit of a contradiction. I mean run the agents locally, but on the remotely connected database.

[wisemx]

Hi,
The Agent is much different than in the past on SQL Server 2008 now.
It doesn't run 'Auto' with the service and I haven't experimented with that like I would have used it years ago...
If you want I can try a few things.
What did you have in mind? I'm guessing in advance the DASP servers will list.
All the best,
Mark

[Guest]

Hi,
To be honest, it's not a crucial aspect at the moment. It was just something I had in mind for the future. The task was to simply delete records, from various tables, that were older than a certain date. Instead of doing this in code, I could schedule an agent to scan every night to keep the tables trimmed.
Thanks

[wisemx]

Hi,
I've got contacts with some of the best Microsoft DBA's and SQL Server Evangelists so I'll put the word out and see if any of them have an example of a local package doing that sort of thing with the Web edition.
I feel comfortable in advance saying it will work here unless it requires a Trigger.
File Stream and Triggers are not supported but everything else is a breeze. ;-)
All the best,
Mark

[Guest]

Hi,
Thanks for the speedy replies! It won't be based on any triggers, just a straightforward scheduled (daily) task. I'm liking the optimism :D

[Guest]

Oh, I don't know if it helps, but I have a licensed SQL Server 2005 Developer edition. I know you can't use this for production, but I don't know if that includes running agent tasks from the local machine to a remote database.

[wisemx]

Hi,
My advice, ditch the 2005 Dev copy and get SQL Server 2008 Dev.
You can get a copy on Amazon for under $30 and it has every feature of the Enterprise version, yes you can use it locally for anything production but not as a production server, which is no problem for anything related to the Web edition, don't fret.
There are lots of Microsoft events you can attend to get a free copy of SQL Server 2008 Standard edition but the Dev edition is much better for this.
I'm running the 2008 Dev edition on Win7 and it does not lag the machine at all, ever. Sweet.
btw, the Express version of SQL Server 2008 is loaded, well, three separate 'loaded' editions of it are available and you can use it for this same thing but the Dev edition for under $30 is an awesome deal.
All the best,
Mark

[Guest]

Thanks for all the help. I'll look into upgrading to 2008. Getting a new computer soon (with win 7), so sounds like a good match :D