I needed to add a schedule to 16 jobs on 16 servers. Again, didn’t feel like clicking thru the gui for all 16 jobs. I ended up using the procedure sp_add_jobschedule. Here’s an example:
Archive for November, 2008
updating tables in batches
At work, I have a table that has a gazillion rows. Last night, I had to update a column with a new value and sometime in the night it failed! FAILED. because the log file got fulled. Fine fine, I added another log file, set it to unlimited growth, what do I care, I just [...]