sql server agent jobs [Resolved]

Posted by Nahesh under Sql Server on 11/30/2013 | Points: 10 | Views : 977 | Status : [Member] | Replies : 4
How to schedule jobs in SQL Server? And how can we check the status of jobs?




Responses

Posted by: Bandi on: 11/30/2013 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
Go to SQL Server Agent under SQL Server object explorer
Select Manage Schedules under Jobs page...
then follow the wizard to schedule as per your requirement.
i.e. every day or monthly or weekly scehdules and so on

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Nahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 11/30/2013 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
You can check the status by using following ways...

1) Job Activity Monitor -- here you can get the details of next run datetime, job status (failed/succeed in the previus run), job category and so on

2) use jobhistory system view
http://technet.microsoft.com/en-us/library/ms174997.aspx

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Nahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: vishalneeraj-24503 on: 11/30/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Hi please visit below links:-

http://stackoverflow.com/questions/7201061/how-to-create-jobs-in-sql-server-express-edition
http://www.dotnetfunda.com/forums/show/16971/sql-server-agent-job-schedules
http://stackoverflow.com/questions/487675/how-can-i-schedule-a-daily-backup-with-sql-server-express
http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express

Nahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 12/1/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Click on "Mark This response as answer " if you got direction from the repies

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Nahesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response