SCHEDULE TASK

The name of my executable file is "Auto PrintQueue.EXE"
(This program opens  MS Word Application and does Mailmerge for different documents & prints it to the printer and closes all the documents and ultimately closes Word application)
This program runs great if run it manually.
If I schedule the task to run in SQL server, the program execution starts but never closes MS word application and prints the results.
Any help is appreciated

Thanks
SumanaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
bamartinoConnect With a Mentor Commented:
Open application with autoprintqueue.exe but inside Word create an autoexec macro to do the rest including closing Word.
You can run any application that supports autoexec macros/batches just using xp_cmdshell extended stored procedure.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.