How to create a Job and schedule in SQL

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

SQL

SQL-Server

, +

Dear Friends,

Can any educate me How to create a Job and schedule the same.
Use of

VB

sp_add_job (Transact-SQL)
sp_add_schedule (Transact-SQL)

Regards,
AP

Posted 5-Jun-12 20:03pm

Arunprasath Natarajan

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

codeBegin · Answer 1 · 2012-06-05T20:07:00

Solution 1

Creating SQL Server Agent Jobs[^]
Schedule a Job[^]
Create a Job[^]

How to create a job in sql server[^]
Execution of Stored Procedure for every half an hour.[^]

Posted 5-Jun-12 20:07pm

codeBegin

devsuja · Answer 2 · 2012-06-05T22:49:00

Hi,

First u see what edition u are using for sql server.

Connect to the server

SQL Server Agent - create a new job

In the General Tab fill the database name, owner, category -Database Management

Schedules - Give the name for schedule

Schedule type - Recurring and fill other details as ur need

SQL server Agent should be present in ur sql, it does not support in sql express edition

How to create a Job and schedule in SQL

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to create a Job and schedule in SQL

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us