Schedule Export Fails, Manual run okay | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Schedule Export Fails, Manual run okay


Hi all, I get an error when I try to create a Schedule to Export data to an xls file. The error says ServerProperty is not a registered function name. I can run the export task repeatedly as long as I don’t try to save it as a scheduled job. The user database roles for this login are public and datareader and public for msdb. Someone know what the problem is, a way around it? Thank you
Elle
Run SERVERPROPERTY to get information of the server from the machine. If possible try to schedule the package from other machine with sQL client tools installed.
KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 for scheduling DTS packages. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>