sql server agent jobs [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

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

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

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