CODEWITHSUNDEEP
sql-serversqlcmdscheduled-taskssql-job
Hemant Tank
Hemant Tank

Reputation: 1744

Alternative for SQL Job scheduling

We've a simple set of stored procedures that we use for data import in our SQL 2005 db. There's going to be a master SP which will trigger those SP one by one. In past we have used SQL Agent and scheduled a job which in-turn executes the Master SP.

Now, if we want to make it simpler and exclude the dependency for SQL Agent & Job - what are our options?

Here's what I've found so far -

There're a lot of options for this so I believe I'll be able to accomplish the SP execution. Is this the correct/best way?

We also need to figure out some other things like -

  1. How to capture the result(s) from my internal SP execution(i.e. record count, etc..).
  2. With SQL-Job we were able to send emails using SQL-Mail. Any options with this approach?

Ref: http://lunarmedia.com/blogs/lunarmedia_blog/archive/2008/02/04/running-a-stored-procedure-from-windows-task-scheduler.aspx

Upvotes: 1

Views: 6411

Answers (2)

Rick
Rick

Reputation: 61

Visual Cron (http://www.visualcron.com/) is quite good for stuff like this - we have it implemented on our Windows servers for all sorts of scheduled tasks. Visibility is better to operational staff as well

Upvotes: 2

u07ch
u07ch

Reputation: 13692

There is a codeplex project for SQL Agent which is worth a look

http://standalonesqlagent.codeplex.com/

Upvotes: 2

Related Questions