Page 1 of 1

Renaming the job or routine

Posted: Mon Jun 04, 2007 4:49 am
by vij
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.

Posted: Mon Jun 04, 2007 6:08 am
by chulett
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!