Renaming the job or routine

vij · Post by **vij** » Mon Jun 04, 2007 4:49 am

Hi all,

is it possible to rename the job or a routine from Adminstrator using a SQL command? If not possible, other than a right click on job/routine, is there any way i can rename the job or routine?
This process is actually taking more than 10 min sometimes.

chulett · Post by **chulett** » Mon Jun 04, 2007 6:08 am

That's because of the 'reference' checks going on. Go to the 'Tools / Options' menu in the Manager and check the Usage Analysis section. Turning off:

* Warn if deleting/renaming referenced item
* Warn if compiling referenced routine

Can speed things up considerably. Make sure you understand what turning them off loses you in the way of functionality, however!