How Do I Schedule A Job In Sql Server 2008 R2

Question

1.00/5 (1 vote)

See more:

How do i schedule a job in sql server 2008 R2. I mean i want to execute some store procedure or sql query in the server time to time basis.Like some query or store procedure will execute automatically in the server after 10 mins and produce some result to the client.

I am using sql Server 2008 R2

Posted 22-Mar-14 3:40am

BIBASWAN

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)

Peter Leow · Answer 1 · 2014-03-22T03:47:00

Solution 1

Refer:
1. Creating Jobs[^]
2. Creating and Attaching Schedules to Jobs[^]

Posted 22-Mar-14 3:47am

Peter Leow

Updated 22-Mar-14 3:50am

v3

Comments

BIBASWAN 23-Mar-14 8:06am

this solutions are ok with the server which sa password i know.But if i dont knw the sa password then how do i set up a job????

Krunal Rohit · Answer 2 · 2014-03-22T04:28:00

Solution 2

Link 1[^]
Link 2[^]
Link 3[^]

-KR

Posted 22-Mar-14 4:28am

Krunal Rohit

Updated 22-Mar-14 4:29am

v2

Comments

BIBASWAN 23-Mar-14 8:07am

this solutions are ok with the server which sa password i know.But if i dont knw the sa password then how do i set up a job????

CHill60 23-Mar-14 12:27pm

"•To create a job, a user must be a member of one of the SQL Server Agent fixed database roles or the sysadmin fixed server role." See http://technet.microsoft.com/en-us/library/ms190268.aspx[^]

How Do I Schedule A Job In Sql Server 2008 R2

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How Do I Schedule A Job In Sql Server 2008 R2

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us