Run Stored PRocedures every morning

[JB]

I've created several stored procedures in the project
server db. What's the easiest way to run a stored
procedure every day at 8:00 am?

[Byron Garbutt]

Good morning JB,

Assuming you are running SQL Server, you can schedule your SP to run via the
SQL Server Agent, which is accessible through SQL Enterprise Mgr ... under
the Management folder. You can define a new job (with multiple steps) to
the job scheduler which also allows for notifications and error checking.
You can schedule a job to run every hour if required. In addition, you can
define maintenance plans (i.e. backups/clean up), as well as DTS (Data
Transformation Services) to import/export data on a pre-defined schedule.

You can also leverage windows scheduling by executing a script or bat file
to invoke your SP but I would highly recommend sticking with SQL Server
capabilities.

Regards,
Byron

"JB" <ijll....@lmco.com> wrote in message
news:003301c2aab1$83c05af0$d6f82ecf@TK2MSFTNGXA13...