Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ismail_issac
Starting Member
22 Posts |
 Posted - 2012-07-12 : 03:23:58
|
| I want to know how to create a invisible job or any sort of invisible mechanism to execute my Stored Procedure. This process should not be visible as I don't want any body to know the details of the jobsThis invisible Job should get executed automatically every day at 1 AM.Can it be possible. Please Help.OR Something similar which we can create in master DB? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-12 : 07:08:09
|
| I don't know of a way in which a scheduled job can be made invisible to everyone including users with administrative privileges.If you would be satisfied with taking away the ability to see the code in the stored procedure, you can encrypt the stored proc. The code would not be visible to anyone.Edit: Correction - there are some users (privileged users over DAC port) that would be able to still see the code even if encrypted, according to MSDN. http://msdn.microsoft.com/en-us/library/ms187926.aspx |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-07-12 : 07:53:20
|
| You can use the Windows Task Scheduler to run a batch file that calls your stored procedure using the sqlcmd utility. It's not truly invisible but it's not part of SQL Server or SQL Agent, and accomplishes the same goal.By the way, someone can run a trace that captures the execution of your job, so I'm not sure what you mean by "invisible" or what you're ultimately trying to accomplish. |
|
|
|
|
|
|
Invisible Scheduled Job