Where are the SQLServer jobs stored?

Posted by Saiyine on Server Fault See other posts from Server Fault or by Saiyine
Published on 2010-12-20T18:54:19Z Indexed on 2010/12/21 12:55 UTC
Read the original article Hit count: 222

Filed under:

sql-server

|

background-process

I'd like to know what is the process a SqlServer job is executing, but I only can find that it calls DTSRun with an encrypted string.

After decoding the string, it results is just the name of the job with the user and the password.

How can I find what is this job really calling?

Edit: I've found a candidate, they could be at the msdb.sysdtspackages, but again, can't read them as SQLServer says the data is binary.

How can I read them to confirm they are the jobs?

© Server Fault or respective owner

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More

Related posts about background-process

Spawn a background process in Ruby

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm writing a ruby bootstrapping script for a school project, and part of this bootstrapping process is to start a couple of background processes (which are written and function properly). What I'd like to do is something along the lines of: `/path/to/daemon1 &` `/path/to/daemon2 &` `/path/to/daemon3… >>> More
Background process in linux using Ruby on Rails

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I want to do some process such as sending emails or using ffmpeg commands in backgound as it takes to much time. I want it should run in a background. I am using Fedora 10. Also can i check whether my background process is running successfully or not . is it posssible?if yes what would be… >>> More
Bring NSRunAlertPanel to Front in Background Process

as seen on Stack Overflow - Search for 'Stack Overflow'
If you call NSRunAlertPanel() from a background process in Cocoa, the dialogue does not come to the front and instead stays behind other windows. This post (http://stackoverflow.com/questions/2639479/nsrunalertpanel-shows-up-behind-the-active-window) shows that you can bring the dialogue to the front… >>> More
IPhone SDK 4 background process for incoming call

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to track (run some code - or invoke function) when the user get an incoming call. for example: for every call the user receive I want to save the number, and check something during or before the call is answered (with a background process..) until now without the background processing… >>> More
Run an application as background process

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, I have developed a Java application. I want to run it as a background process. It should not be displayed as Running Application in task Manager, but it should be displayed in Processes List. Help me out. Regards, Jigar >>> More