Get Job Information

Sep 6, 2007

I am trying to get job information and have a query set up. However, I would also like to get the owner information. However, the job only stores the sid of the owner. Does anybody know how I could change this query to get the owner name instead of sid? Don't want to use the sp_help_job command.

SELECT @@SERVERNAME AS Server, msdb.dbo.sysjobs.job_id, msdb.dbo.sysjobs.name, msdb.dbo.sysjobs.enabled AS Job_Enabled,
msdb.dbo.sysjobs.description, msdb.dbo.sysjobs.notify_level_eventlog, msdb.dbo.sysjobs.notify_level_email,
msdb.dbo.sysjobs.notify_level_netsend, msdb.dbo.sysjobs.notify_level_page, msdb.dbo.sysjobs.notify_email_operator_id,
msdb.dbo.sysjobs.date_created, msdb.dbo.syscategories.name AS Category_Name, msdb.dbo.sysjobschedules.next_run_date,
msdb.dbo.sysjobschedules.next_run_time, msdb.dbo.sysjobservers.last_run_outcome, msdb.dbo.sysjobservers.last_outcome_message,
msdb.dbo.sysjobservers.last_run_date, msdb.dbo.sysjobservers.last_run_time, msdb.dbo.sysjobservers.last_run_duration,
msdb.dbo.sysoperators.name AS Notify_Operator, msdb.dbo.sysoperators.email_address, msdb.dbo.sysjobs.date_modified, GETDATE()
AS Package_run_date
FROM msdb.dbo.sysjobs INNER JOIN
msdb.dbo.syscategories ON msdb.dbo.sysjobs.category_id = msdb.dbo.syscategories.category_id LEFT OUTER JOIN
msdb.dbo.sysoperators ON msdb.dbo.sysjobs.notify_email_operator_id = msdb.dbo.sysoperators.id LEFT OUTER JOIN
msdb.dbo.sysjobservers ON msdb.dbo.sysjobs.job_id = msdb.dbo.sysjobservers.job_id LEFT OUTER JOIN
msdb.dbo.sysjobschedules ON msdb.dbo.sysjobschedules.job_id = msdb.dbo.sysjobs.job_id

View 1 Replies


ADVERTISEMENT

SecurityException Class SQLServerDatabaseMetaData's Signer Information Does Not Match Signer Information Of Other

May 23, 2007

Hello,

I have some troubles with IBM WebSphere Application Server using MS SQL Server 2005 JDBC Driver. I always get the error e.g.
java.lang.SecurityException: class "com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData"'s signer information does not match signer information of other classes in the same package

I found this Feedback but it seems to be closed.

A temporary solution for me was to delete the meta-inf directory of the JAR-File, but that can't be the solution.

Can anyone help me with this problem?

Simon

View 4 Replies View Related

Information About A Job After It Ran

Jul 2, 2001

I have a job that runs each night that deletes all records from a table that are older than two weeks old. Is there some way I can view how many records were deleted from the table each night. Is it written to a log somewhere? Thanks in advance!

View 1 Replies View Related

Getting Information

Aug 4, 2005

Hi all,
This is my first thread here.
I got an information about
SET NO_BROWSETABLE ON/OFF
in your forum.. The replier told that this is an undocumented option.
My question is how you guys find information on such undocumented things....

Thanks in advance.
Saint

View 1 Replies View Related

Information !

Mar 26, 2008

Hello,

Can anyone clarify the nuances of How to deal with the change management environment in SQL Server.

Thanks.

View 3 Replies View Related

Information Being Cut Off

Mar 17, 2008

I have a report where the information is getting cut off the report.

At the beginning of or at the ending of the page it is dropping the information.

My layout setting are set 8.5in wide by 11in height. .5in for either left or right margin. 1in for top and bottom.

I run the report and I'm missing a record.

I adjust the height to 10in to force diffferent page breaks and it's there.

I have the setting in one of the groups set for a page break at end. If I uncheck that it doesn't help.Still no records.

What is going on?

View 5 Replies View Related

Looking For Information

Mar 15, 2006

I'm looking for books or information on command line configuration of settings for things like activating Remote Connections under the Service Area Configuration and setting a port for that connection.

What books would be good to get or where can I download papers on this?

Any help would be appreciated.

View 1 Replies View Related

Locking Information

Dec 23, 2005

Hi!This is a very simple question and I'm sure you guys will help me a lot.I'm using Visual Basic 2005 for programming. I have one table on my MS SQL 2005 database that has an int column with a counter that needs to be incremented when a user registers.So when reading the value I use a simple SQL query like this:
SELECT counter FROM companies WHERE company=0
then I store the value in a local int variable and then I increment it. Then I update the incremented value.
UPDATE companies ...
I need every single customer to have an individual value. My question is how can I prevent an error, data corruption or whatever if two or more users want to register at the same time? I've been reading about lock update but I'm not sure how to implement it on Visual Basic 2005 and I don't want to store scripts on SQL Server.
I'll appreciate your comments and help on this situation.

View 15 Replies View Related

Trigger Information

Jul 26, 2001

Hi,
I have a problem here in my SQL Server Database. I want to find which trigger is working backend affecting my table input. Since the original author of this trigger was somebody else, I am not able to find the trigger information
A simple line of syntax would be great.
Thanks in advance
sandeep

View 1 Replies View Related

Last Login Information

Aug 30, 2001

I am doing an audit of user information in our database and was wondering if there is a way for me to see the last time a user logged into the database. I am using a SQL Server 7.0 box. Any Information would be greatly appreciated. Thanks!

View 1 Replies View Related

Alias Information In 70

Jun 27, 2000

Hi,
In my database one user is aliased like a guest. When i run sp_helpuser on the particular database it is giving following result.

username login name database
-------- ----------- --------
aaaa NULL XYZ


NOrmally we fill see like this for GUEST User. Now i want to drop this user 'aaaa' only. IF i use
sp_dropuser 'null'
i think guest user will also drop from XYZ database.
So can anyone pls suggest me how to drop this user. I have to add a same user with full permissions. i know in 65 we have sysalternates table gives all alias information. Is there any table gives the same information in sql7.
Pls suggest me regarding this.

thank u
raj

View 1 Replies View Related

HELP (URGENT) Need Information!

Sep 26, 2000

Hi,

I administering SQL server and one of or Db (size ~7 Gb) have a table with size 396 MB and 25 indexes created on this one. We working with this DB using Siebel Call center.
I have met a very strange situation: when I tried to get some data (using Siebel) my request take ~5 min. I run Profiler and catched this T-SQL statement which Siebel send to SQL server. After that, I run this T-SQL query using Query Analyser and found that Query Optimiser used wrong index. (clustered index) and try to compare every 470436 rows from the tables.
This is the statement. @P1, @P2, and @P3 just variable which siebel transfer to SQL server.

SELECT ........
FROM
dbo.S_EVT_ACT T1
LEFT OUTER JOIN dbo.S_CONTACT T2 ON T1.TARGET_PER_ID = T2.ROW_ID
WHERE
((T1.APPT_REPT_FLG != @P1 OR T1.APPT_REPT_FLG IS NULL) AND
(T1.TEMPLATE_FLG != @P2 OR T1.TEMPLATE_FLG IS NULL)) AND
(T1.SRA_DEFECT_ID = @P3)

But I found the very strange situation - when I manualy put the value '1-FRK' instead of @P3 - Query Optimizer used RIGHT index and I had a very good performance.


And addition when I tried to run the first Query on the same table but with the only 1000 rows the Query Optimiser choose right index.


Wat's on, wat happend with My Query Optimizer? Wy his decision so different from time to time?


Thank's a lot for any information about how to make Optimiser obedient.

View 5 Replies View Related

Getting User Information

Jan 19, 2005

I need to write an auditing trigger that will capture time of an insert and user that is making the insert. The time part i think i can use getdate(), but how can I find out which user is making the insert? Any help appreciated.

View 2 Replies View Related

Login Information

Oct 3, 2005

Hi,

Can we retrieve the Login Failed and succedded for SQL Server?

I want to know the login failed and succedded information of SQL Server.

Can we retrieve the same?

Let me know ASAP.

Thanks and Regards,
Pramod

View 5 Replies View Related

INFORMATION ON PROCESS ID

Nov 17, 1998

Is there any way to use Transact SQL to get the detailed information on a process like you get when you use the GUI interface under the Enterprise manager for server activity.

Thanks!

View 1 Replies View Related

Trigger Information

Jul 26, 2000

Is there a way to view the triggers on a table using query analyzer?

I have a developer that wants to see this information without having to right click every table in the database and viewing the triggers through enterprise manager.

Thanks,

Brad

View 1 Replies View Related

Logon Information

Feb 15, 2001

I just started at a new company. The security stinks, everyone logs into the servers as sa (including many applications). I am taking steps to tighten security and restrict access to the sa login. I would like to capture some additional information at logon as an interim measure.

Can anyone assist me in automatically recording the following:
Host Name / IP Address
Login time

I realize I could periodically run an sp_who2 and capture the results - I also realize that if I turn on auditing, the logon will be written to the SQL Srvr LOG - I'm looking for an elegant / low impact way to capture the logon and host information.

Thanks in advance for any help.

Scott Wright

View 1 Replies View Related

Need Help Getting Information From 2 Tables At Once

Jan 2, 2002

I'm trying to access data from one table by matching ids pulled from another table. I can't quite get the syntax though if anybody could help I would appericate it.

Here is where I'm at

select * from table1 where variable 1 = (select distinct(variable 2) from table 2 where variable 3 = variable 4)

View 2 Replies View Related

User Information!!

Jun 24, 2004

Hi,
I'm trying to get the information about the user who modified the record in the table. I'm able to capture the datetime of modification through trigger.

CREATE TRIGGER [upd_dtm] ON dbo.Sample
FOR INSERT, UPDATE
AS
BEGIN
UPDATE Sample SET update_dtm = (SELECT GETDATE())
WHERE Sample.ID IN (SELECT ID FROM inserted)
END

I'm stuck, how to get the User who modified it?
Any help is greately appreciated!

View 8 Replies View Related

Job Schedule Information

Nov 7, 2005

Hi,
Does anyone has a script to find out what are the scheduled timining for all sql server agent jobs.
I'm trying to get the result with the following query, it doen't seem working..

select sj.name,
case sjs.freq_type
when '1 ' then 'Once'
when '4' then 'Daily'
when '8' then 'Weekly'
when '16' then 'Monthly'
when '32' then 'Monthly relative'
when '64' then 'When SQL Server Agent starts' end as Frequency,
case sjs.freq_interval
when '1' then 'Sunday'
when '2' then 'Monday'
when '4' then 'Tuesday'
when '8' then 'Wednesday'
when '16' then 'Thursday'
when '32' then 'Friday'
when '64' then 'Saturday' end as DAY
from sysjobs sj, sysjobschedules sjs
where sj.job_id = sjs.job_id


Any help would be greately appreciated.
Thanks

View 2 Replies View Related

Passing Information

Jun 21, 2007

What i am trying to do is have the contact information to be displayed also. The contact information is in dbo.CONTSUPP under column 'contact'. Is there anyway to pass that 'contact' value up to the parent select statement. So the result will show Company, Address1,...,Source, contact.

SELECT Company, Address1, Address2,
Address3, City, State, Zip,
Country, Phone1, Fax, Source
FROM dbo.CONTACT1
WHERE dbo.CONTACT1.ACCOUNTNO IN (
SELECT ACCOUNTNO
FROM dbo.CONTSUPP
WHEREcontact LIKE '%test1%' OR
contact LIKE '%test2%' OR
contact LIKE '%test3%' OR
contact LIKE '%test4%'
GROUP BY ACCOUNTNO
HAVING COUNT(*) <= 1
)

View 2 Replies View Related

Where Is The Transaction Log Information Kept?

Feb 27, 2004

I'm assuming that in one of the MSDB tables I can find transaction log information (current size, amount of space used.. blah blah).. but I can't seem to figure out which one.. any help is appreciated.. SQL 7.0

Travis

View 4 Replies View Related

Detailed Log Information

Apr 5, 2004

We just started using SQL Server. I'm new on the SQL side of things. We have SQL setup in a test environment with users connecting and performing job related functions. An in house programmer has developed software for our users which connects to the SQL Server

I'm looking for information pertaining to events that have teken place within SQL. Does SQL give you details on updates and changes made to specific tables. I'm looking for some way of looking up item numbers and the user that entered the data. We have noticed that some of the users may be entering in wrong data within certain tables. And would like to educate them on what they are doing wrong.

I need to know what certain users are logging and entering into our SQL Server.

What are the most detailed logs that SQL Server provides that has information on what the users are doing has far an entering in data.

View 3 Replies View Related

View Job Information

May 15, 2008

What access I should give for a non-admin user to be able to view the sql-job information?

------------------------
I think, therefore I am - Rene Descartes

View 10 Replies View Related

Triggers Information

Oct 12, 2006

Hello good morning friends.

can you please send me some links regarding triggers from basics to gain indepth knowledge. i tried in google, but due to limited access in ouroffice,i can not find the best.


thank you verymuch

Vinod

View 1 Replies View Related

Storage Information

Feb 23, 2007

additional to data, what other type of information can be store in sql databases, i need to store pictures and mp3's that can be done, if not do you know what storage can be used for this purpose?

View 2 Replies View Related

Request For Information

Aug 22, 2007

I am not sure if this belongs under this forum or 'New to SQL' so please feel free to move it if necessary.

Following on from an issue i have had with sysdepends and syscomments tables filling up, I have been trying to research what these tables are and how they get filled up (i.e. what is the trigger to insert a row into these tables).

Unfortunately on all my web searches and book searches i have not found anything much more than 'They are system tables'. From what i have gleaned, it looks like every time a stored procedure or database object is changed, then this will create a new entry into the sysdepends table which highlights what the new object is linked to.

Is this understanding correct? And does anyone have any other sources of information which might give me a better idea of what and how these tables are about.

Many thanks in advance.

Mark

View 2 Replies View Related

Help Me In Finding Information, Please

Sep 6, 2007

How can i use a decieving phrase for using in a SQL server that work with number?

i mean for finding the information you have to enter a number... is there any way to enter something else and recieving information?

plz email me if it is possible... it's bbk_agp AT Yahoo DOT com

beforhand thanks very much

View 8 Replies View Related

Joins Information

Nov 2, 2007

Hi,

I am new to sql programming.please let me know what is difference between the inner join,outer join.which one is the fast?why?

Thanks,
dba75

View 8 Replies View Related

Collect DB Information

Jan 20, 2008

Hi,

We have a few Analysis Server databases. I need to go to each server/database and in a Word document write the information for each server/database. For example I have a database called Analysis Services Project 1 with Data Source dsIIBSW. I need to write it in a document. Is there a fast way of doing that?
Thanks

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

View 2 Replies View Related

Dbo.dtproperties Information

Aug 9, 2005

Hi AllI understand the dbo.dtproperties tables is a system table, but it appearsunder "User Tables" in my Query Analyzer.Is this normal , or does it signify a problem ? I have never seen it therebefore.In the sysobjects table, the xtype field and type field for dtpropertiestable, have been set to 'U', which I thought meant User.Perhaps I should just set them back to 'S' ?All sugestions welcomedCheersRay

View 1 Replies View Related

Where Thread Get The Information?

Sep 26, 2007

Hi.


I want to get the current value of culture that my multilanguage application used.

So, i type this line of code :


string getLanguage = "";


getLanguage = Thread.CurrentThread.CurrentUICulture.ToString().Trim();

The thing that I dont understand is, where the thread get the information from? My windows application currently set to "zh-CHS" culture but my pc that running the application is "en-US".

It seems like the thread get the information from my pc. What i want is, getLanguage get the information from the application.


Is that can be achieved? Please explain to me...

View 1 Replies View Related

Getting Connection Information From A DSN

May 2, 2007

I've defined a System DSN (and it works just fine for the classic ASP web site) and for a separate project I would very much like to determine what server its connecting to.

My environment is .Net 2.0.

On some boxes, the DSN is configured to connect to SQL Server "George" and on others it's configured to connect with "Carl." Both servers have a database named Lighhouse, I want to connect to another DB using the newer SQLConnection/SQLCommand objects. Which, don't support and ODBC DSN in the connection string. However, when constructing my connection string I need to connect to the same server that's defined in the DSN.

Is there a way extract the information from the DSN?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved