What happens to the system agent tables whenever the database server is restarted? More specifically, does SQL Server assign new job_ids to each job when they are run after the reset, or does the job_id stay the same?
+1
A:
The job ID is assigned at the time of job creation and remains static after that point.
Joe Stefanelli
2010-07-15 19:43:21