Sep 23, 2008 07:53 AM|hobbes1965|LINK
It can be done but you have to do some tricks :
I created a sql job and included one step, this is an cmdexec step using this command:
"C:\Program Files\Internet Explorer\iexplore.exe" "http://localhost/webpage.aspx?ACTION=DOSOMETHING"
in my code I act upon this action parameter by starting a proces (code is from the page_load function in my webpage):
"window.opener = 'x';" +
The second part is important : by setting the window opener to 'x' no question is asked when closing this webpage, window.close automatically closes the browser window.
This solves the endless running job. Using explorer as the host won't kill the job, iexplorer does kill the job. I need a full path to ieplorer because no path is set to iexplorer on the sql server I think.
SQL JOB WEBPAGE