November 8, 2006 at 10:29 am
My name is José Luis Moreno Ubeda,
I am a nicaraguan systems engineer,
I work like Analyst Developer of Software.
In SQL Server 2000, I had created sp, a Job, an error, an operator and an alert through
T-SQL.The steps that job made are the following ones, every day to 12:00 p.m. executed sp dynamic with parameters that endorsed 4 bds of a Server automatically protected by password, if sp failed, the work shot a tie error to the alert before mentioned and towards arriving a notification at certain operators from the failure in the endorsement so that automatically problematic one was verified this.
Now in SQL Server 2005 I cannot dynamically create these elements with script that we had in T-SQL.
Since this required to temporarily qualify the direct edition in system catalogues (bd masters), to add the new error, it alerts, operators etc, from script.
Since I can do this, if SQL 2005 does not allow the updates ad hoc? I must form the Job of artisan form, the error, operators, sp, alert for each server that will use east Job?
We cannot waste time and resources manually doing this. I would like to know a solution on the matter.
Sorry for my bad english.
November 8, 2006 at 11:03 am
Jose Luis,
You can do all that without using any "tricks" regarding system tables
have a look at:
sp_add_operator
sp_add_job
sp_add_jobstep
sp_addmessage
sp_add_alert
The easiest way I can think of is you create one job then you script it out and then you run the script on each of the servers. I still don't understand why are you saying that you can't do it in SQL Server 2005
Regards,
* Noel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply