The sql-server-agent tag has no wiki summary.
4
votes
1answer
1k views
How and when does SQL Agent update next_run_date/next_run_time values?
I've been working on code in T-SQL to add new schedules to a SQL Agent job using the sp_add_jobschedule proc in the msdb database. When I add a new schedule (typically a run-once at a specific ...
3
votes
4answers
1k views
What's a good tool for visualizing SQL Agent jobs?
I find the built-in MS SQL Studio tools for managing Agent jobs to be a little frustrating. What tools out there have you found helpful?
Offhand, there are three things I'd like to see in such a ...
2
votes
2answers
828 views
Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
At times, I'm seeing some inconsistencies with sql server agent's value in the sysjobschedules.next_run_date and time fields.
I have a web interface that interacts with the sql scheduling system.
...
1
vote
4answers
450 views
Could not find the Server Agent in SSMS
I am following the guide - http://sqlserverpedia.com/blog/sql-server-bloggers/how-to-create-a-server-side-trace-with-sql-profiler/ which is working until I reach Step 8
8. Now to schedule your newly ...