Ravo's example works, I've been using that method for quite awhile now with no problems. One thing to note, I couldn't get this working until I set up a "Non-SysAdmin job step proxy account". You can do this by selecting the properties of the SQL Server Agent then choosing the "Job System" tab. You have to un-select the "Only users with SysAdmin privelages can execute CmdExec and ActiveScripting job steps" and then enter an account. Do some Googling on this though, as it can be a security risk in some envrionments.
>Cool...I'll check yours out first. > >Now, of course, I'm off to fight fires that always pop up at the worst >possible times. Grrr... > >Snake wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247638 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
