This is about adding a new SQL Jobs in the Sql Server 2005.
Make sure that the SQL Server Agent is up and running. You can see it in the taskbar
If SQL Server Agent is not running, start it from the SQL Server Configuration Manger
You can also start the SQL Server Agent from the command prompt using the command
net start "SQL Server Agent (<instance name>)"e.g net start "SQL Server Agent (SQLSERVER01)"
Connect to the database engine of SQL server using SQL Server Management Studio.
Expand the SQL Server Agent. You will see a Jobs folder over there. Right click
on jobs and choose Add New.
A New Job popup will appear. Specify the name of the job.
Cilck next on the "Steps" in the left menu. A sql job can contain one or more steps.
A step might be simply an sql statement or a stored procedure call. Add you step
Job step added
Cilck next on the "Schedules" in the left menu. A sql job can contain one or more
schedules. A schedule is basically the time at which sql job will run it self. You
can specify recurring schedules also.
Job schedule added
You sql job is ready now. However there are other thing you can use if needed like
Alert, Notifications etc.
I want solution of this:- If I created 2 step & I want to create two different schedule for each step(e.g 1 st sql step execute on 12 am & 2 nd step execute on 1 am) Is it possible to create 2 schedule in single job with two step???
Hi, can any1 just provide me the query for rescheduling ssrs reports through stored procedure? I hve scheduled through script but I want through sp to pass next run date and time and it has to be triggered...