1 2 /* Sccsid = "%Z% generic/sproc/%M% %I% %G% */3 4 /*
5 ** Messages for "sp_rjs_unregister"
6 **
7 ** 17260, "Can't run %1! from within a transaction."
8 ** 19364, "'%1!' is not a valid server name."
9 ** 19369, "A Job Scheduler server name is required; enter the name of the server with JS installed that you want to unregister."
10 ** 19370, "A host name is required when unregistering a Job Scheduler server."
11 ** 19371, "A host port number is required when unregistering a Job Scheduler server."
12 */13 14 createproceduresp_rjs_unregister15 @js_server varchar(30),/* name of js server */16 @host_name varchar(255),/* name of machine hosting JS server */17 @host_port int /* server access port on host */18 as19 begin20 21 /*
22 ** If we're in a transaction, disallow this since it might make recovery
23 ** impossible.
24 */25 26 if @@trancount > 0
27 begin28 /*
29 ** 17260, "Can't run %1! from within a transaction."
30 */31 raiserror 17260, "sp_rjs_unregister"
32 return(1)33 end34 else35 begin36 /* Use TSQL mode of unchained transactions */37 set chained off38 end39 40 /* Dont do "Dirty Reads" */41 settransactionisolationlevel 1
42 43 /*
44 ** Check to see that the input params are correct and then hook up with
45 ** sysattributes table to enter data.
46 */47 if((@js_serverisNULL)OR(@js_server= ""))48 begin49 /*
50 ** 19369, "A Job Scheduler server name is required; enter the name of the server with JS installed that you want to unregister."
51 **/52 raiserror 19369
53 return(1)54 end55 else56 begin57 if valid_name(@js_server)= 0
58 begin59 /*
60 ** 19364, "'%1!' is not a valid server name."
61 **/62 raiserror 19364,@js_server63 return(1)64 end65 end66 67 if((@host_nameisNULL)OR(@host_name= ""))68 begin69 /*
70 ** 19370,
71 ** "A host name is required when unregistering a Job Scheduler server."
72 **/73 raiserror 19370
74 return(1)75 end76 77 if((@host_portisNULL)OR(@host_port= 0))78 begin79 /*
80 ** 19371, "A host port number is required when unregistering a Job Scheduler server."
81 **/82 raiserror 19371
83 return(1)84 end85 86 /*
87 ** The following sysattribute columns hold the corresponding data for
88 ** a unregistered JS:
89 **
90 ** object_type: JS
91 ** object_cinfo: ASE server name
92 ** char_value: host name
93 ** int_value: host port
94 **
95 ** Note: in future, if we want to unregister more than one Job Scheduler
96 ** server, we have a natural key in object_cinfo (@js_server),
97 ** char_value (@host_name) and int_value (host_port).
98 */99 deletefrommaster.dbo.sysattributes100 whereclass= 22 andattribute= 1 andobject_type= "JS" and101 object_cinfo=@js_serverandchar_value=@host_nameand102 int_value=@host_port103 104 return @@error
105 end/*end sp*/106