sql sql-server-2008 sql-server-2008-express

Scheduling daily task on SQL Server 2008 database

I'm using SQL Server 2008 and trying to make schedule to run a page every mid-night but I don't know how to do it. I already tried to do with SQL JOBS but couldn't find JOB folder.

Solution

If you are using a full SQL Server product (not Express), just follow the steps from Books Online

http://msdn.microsoft.com/en-us/library/ms191439%28v=SQL.100%29.aspx

FYI - The folder "Jobs" is under "SQL Server Agent" in the Object Explorer tree.

If you are asking about Express, then refer to answers in this SO question or a neat trick using SQL Server Service Broker

Filter rows using Row number and partition by columns and a business logic
How to check the existence of related records in group by query?
I can't call the data properly into my html page
SQL triggers column updating sequence
Return entries within last 24 hours of a specific date time in SQL
Codeigniter using LIKE with WHERE in SQL query
Case causing ORA-01790: expression must have same datatype as corresponding expression error
Create multiple OR LIKE conditions on the same column using CodeIgniter query building methods
Script to save varbinary data to disk
Excel VBA create 2 temp tables and enter the output into a third temp table and output to excel sheet
Generate report converting rows into column using multiple tables
How to debug SSIS package in SQL Server Management Studio 2017?
Update multiple column of a SQL table based on another table
How to sum 2 values from different queries?
"ERROR: invalid input syntax for type numeric: NULL" postgresql
"The big SQL RegEx": How do I RegEx split an easy SQL query (SELECT ... INTO ... FROM ... WHERE ... GROUP BY ... HAVING ... ORDER BY)?
VBA To Parse Userform Name In Method
Match a list of patterns using SQL IN and LIKE
DuckDB: how do I use the result of a query on `DESCRIBE` to `SELECT` from a table?
Delete all similar rows except first one
Installing MySQL on the D: drive instead of C:
Adding an index to query result
Update records in a SharePoint List by SQL via VBA/ADO?
Return rows where column value is final superset of preceding rows
Is there any intuitive reason why SQL syntax is handled in this order?
Assign Updated Time when a specific column change in SQL
Converting bytes to kilobytes/megabytes
Insert multiple rows at once with CodeIgniter's active record method
JOIN query causes column name collisions in SELECT * clause
Conditionally add an OR WHERE IN () condition using CodeIgniter's query building methods