StrongCoders.CSJobs
I've created the following Community Server jobs:
BlogActivityNightlyJob - Executes the cs_BlogActivityNightlyJob stored procedure.
UserActivityNightlyJob - Executes the cs_UserActivityNightlyJob stored procedure.
This elimates the need to run those stored procedures as SQL Jobs. You can download StrongCoders.CSJobs
here
. The download also contains a Control Panel add-in that allows you to manually run the jobs.